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

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