Get instant live expert help on How do I get row number

“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

Post your problem and you’ll get expert help in seconds.

Our professional experts are available now. Your privacy is guaranteed.

Here are some problems that our users have asked and received explanations on

Below in Column 2 there are some numbers given how to calculate sum of numbers based on the criteria given in the start row number and end row number Formula should be capable enough, if we change start row number and end row number sum will get update
Solved by X. J. in 17 mins
If i want to erase duplicate number on Row D, what do i need to do to get the whole row horizontal erase with the number that is erasing on row D??
Solved by X. W. in 27 mins
if i have a number say, 1326011859 and this # appears on 17 different rows with different values per row. How do i get excel to roll up all 17 rows under this number
Solved by G. W. in 18 mins
hi what is the formula for something like this: ='sheet1'!H & current sheet('sheet2'!) A2 (A2 contains row number as number) example: sheet 1 column a contain text: Apple, Bannana, Coconut, Apricot... column b contains buy price.... column c contains sell price... column d contain stock.. sheet 2 after i find row number using =MATCH(A2, 'sheet1'!A1:A3456,0) how proceed to get value of sheet 1 column b by using row number what i just find earlier Thanks
Solved by G. H. in 18 mins
Hi, I'm making a shedule calculating number of days with function (row 4) with number of hours/function (row 2). =(G4*G2)+(H4*H2)+(I4*I2)+.... Colum marked PROBLEM How can i get excel to do the same calculation for 2 rows for all functions G to AK. i.e =(G4*G2)+(H4*H2)+(I4*I2) + ... until (AK4*AK2)
Solved by X. C. in 21 mins