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

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

what I need to do is in row 2 what I type below row should be filtered.
check sample file I have attached. In row c2 and d2 I will write any number and below row should be filtered. how can I do it with VBA or any other way?

Solved by S. Q. in 24 mins

New to Excel so apologies for what I assume is a fairly basic question. I want a row to automatically work out a figure that is 50% of what is mentioned in a subsequent row. Is that possible and, if so, how please?

Solved by G. D. in 13 mins

what is a statement number on an excel invoice document?

Solved by C. A. in 12 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