Hi all How to get summary of bill number as mentioned in the attached excel file
S sadasivan New Member Apr 17, 2018 #1 Hi all How to get summary of bill number as mentioned in the attached excel file Attachments Bill No Summary.xlsx 135.9 KB · Views: 3
chirayu Well-Known Member Apr 17, 2018 #2 technically it look like you're doing day summary so easy enough to do. excel file attached. Attachments Bill No Summary.xlsx 130.2 KB · Views: 5
GraH - Guido Well-Known Member Apr 17, 2018 #3 Or may be an alternative with a simple pivot... Disadvantage it needs a refresh when data is renewed. But is without the formulae. And it could directly work for more then 1 month of data as well. Attachments Copy of Bill No Summary-1.xlsx 137.8 KB · Views: 4
Or may be an alternative with a simple pivot... Disadvantage it needs a refresh when data is renewed. But is without the formulae. And it could directly work for more then 1 month of data as well.