LinkBack URL
About LinkBacks
Is there a way to combine the lines of a spreadsheet if the first coloum is the same, but coloum b,c has different data?
see attachment for info
Line 1-3 is the same in coloum a
but i want it to look like line 9 since coloum A is the same..
Is there a way to combine the lines of a spreadsheet if the first coloum is the same, but coloum b,c has different data?
see attachment for info
Line 1-3 is the same in coloum a
but i want it to look like line 9 since coloum A is the same..
Then copy to right, or copy down.
b9=INDEX(B$1:B$8,MAX(IF(($A$1:$A$8="hello")*(B$1:B$8>0),ROW(B$1:B$8))))
I need your support to add reputations if my solution works.
I'm not sure what this does and how I am supposed / where to add this code.. Iam not sure what you are saying..
Myk3
1. Open your file "Book1"
2. Go to sheet1, Cell b9
3. Insert the following fomula
4. Ctrl + Shift + Enter.=INDEX(B$1:B$8,MAX(IF(($A$1:$A$8="hello")*(B$1:B$8>0),ROW(B$1:B$8))))
5. select B9 again, Copy,
6. Select C9 D9, Paste
7. Done
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks