Get instant live Excel expert help with Text Functions

Hello. I cannot get this formula to work. The two address functions work fine independently but not inside of the Median function. I suspect it's due to the fact that the Address functions result in a text value and the colon separates the two functions, but I'm baffled. Your assistance is appreciated. =MEDIAN(ADDRESS(COUNTA(B:B)-5,2):ADDRESS(COUNTA(B:B),2))

I am trying desperately to convert text to number excel in order to be calculating simple sum formula. Used multiple help sites- all the methods seem to work with some of my sheets but not with the one I want!

Hi, I have problem with formula MATCH and reference cell. I have created a column of range values, for example like this: Z1=A1:A10, Z2=B1:B10, Z3=C1:C10... I first use VLOOKUP to find the cell with range I need and that I use the result in MATCH formula instead of range - cell reference to the range. I get N/A error. I think the problem is that Vlookup returns "range" value as text. I tried multiple ways to change it to general or number data type but nothing works. Also I tried to go around and use combination of index and match to come to the same result but it returns the same N/A value. I am out of options how to fix it. Any advice?

Auto populate cell with text dependent on a dropdown box.

I want to create a list of cells which are >0 from B1:B36 however instead of giving me the B values I want the corresponding text from column A. eg. B24 = 1, B25= 0, B26 = 1, A24 = x, A25 = y, A26=z therefore my list would read x, z. Hoep this is somewhat clear.

I have a text box at the top of my excel workpapers. In the past, when printing out the excel spreadsheet, I would select "fit all columns on one page" or "fit on one page" and the text box would automatically resize. Now for some reason it is no longer auto resizing the text box. Even when I go back to the saved workpapers that did not have a problem previously, I am unable to reprint the out. I have right clicked on the text boxes, selected format shape, then selected text options and the box under properties "move and size with cells" is selected. I am not sure why all of the sudden this is happening.

Cell B22 is returning text of (=(SUM($E2/12)) and I want it to run the value in E2 and divide by 12

Trying to create a quick formula to remove spaces and add text

This is a less excel technical question, but more of a system problem. After pressing some buttons, the size of my Ribbon and the text on it became enormously big, however, the text, and the column headings etc, on the worksheet were fine. I tried many ways, yet still cannot find a solution to turn the size to normal. I am using a Windows 10, and the version of my Excel is 2016. Many of the tutorial online does not match my version.

Hi I want to work out 80% of a cells value but only if another cell in the row contain specific text. Can you help please