Get instant live expert help on How do I get cell address excel
“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”
Here are some problems that our users have asked and received explanations on
Please help me understand the function. =IF(C$2+$A3<=60,SUM(INDIRECT(BM$2&ROW()&":"&CELL("address",OFFSET(C3,0,$A3-1)))),""). I don't get the SUM(INDIRECT(BM$2&ROW()&":"&CELL("address",OFFSET(C3,0,$A3-1)))) Part
Solved by X. J. in 23 mins
when I open the excel file I get an error saying "We can't connect to 'https://####-my.sharepoint.com/#### Please make sure you're using the correct web address.
Solved by D. E. in 14 mins
Hello: 1st goal is to create an excel address list using addresses from mom's personal hard copy address book. 2nd goal is to print Avery address labels from the Excel list to put on postcards. okay, many of mom's addresses are couples with same last name. Question: How do I enter the two first names in one Excel cell so it ultimately prints on label as - example: George & Shelly Smith (for example).
Solved by O. U. in 30 mins
Hi, I have this formula: =ADDRESS(CELL("row",INDEX(Overview!A:A,MATCH($B$1,Overview!A:A,0))),CELL("col",INDEX(Overview!1:1,MATCH((INDIRECT(ADDRESS(ROW()-1,COLUMN()))),Overview!1:1,0))),1,0,"Overview"). The result is Overview!R4C3 which is correct but I want the value of that cell not the address. Can you help?
Solved by C. C. in 26 mins
I need an "if" formula in excel to use range that I had got in another cells as text using a "cell address" formula
Solved by F. F. in 23 mins