Hi guys,
Please help to modify my formula. I have attached a spreadsheet.
Thanks!
Hi guys,
Please help to modify my formula. I have attached a spreadsheet.
Thanks!
If I understood you correctly
enter this array formula in G4 and pull formula to the right and then down
Formula:Please Login or Register to view this content.
***Array formula must be entered by using key combination of CTRL+SHIFT+ENTER and not just ENTER
Data Range
C D E F G H I J 3 1 2 3 4 4 1 10 10 20 30 20 5 2 20 40 50 70 6 3 30 10 60 7 1 40 40 8 2 50 9 2 60 10 3 70 11 1 10 12 4 20 13 5 50 14 1 40
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
Alkey,
Awesome! That's exactly what I needed. Many thanks!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks