Hi
I would like to format rows based on immediate predecessor value of a cell in a column. Please refer to the attached spreadsheet showing the befor and after where the expected result is shown.
Any help would be greatly appreciated.
Hi
I would like to format rows based on immediate predecessor value of a cell in a column. Please refer to the attached spreadsheet showing the befor and after where the expected result is shown.
Any help would be greatly appreciated.
Use Pivot Table, refer the attached file for details.
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
Sixthsense
Thank you for your reply. This does not format the way I had shown. I would like all rows to be formatted and no total shown.
Thanks
Hoss
You can remove the total by just placing the cursor in E23 cell and do right click and deselect Subtotal.
Sixthsense
Yes thanks but this does not format the rows as per my attachment.
Hoss
Sixthsense
Yes thanks but this does not format the rows as per my attachment.
Hoss
Then you should go for VBA solution, but from my point of view merging the cells are not a good method of having data.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks