Y younas New Member Apr 4, 2017 #1 Hi, I have attached an example and manually filled (yellow highlighted) the cells with serial number against each item. Is there any way to automatically fill the yellow highlighted cells by using a formula? Please give a non-vba solution if possible. Younas Attachments Book2.xlsx 11.9 KB · Views: 4
Hi, I have attached an example and manually filled (yellow highlighted) the cells with serial number against each item. Is there any way to automatically fill the yellow highlighted cells by using a formula? Please give a non-vba solution if possible. Younas
PCosta87 Well-Known Member Apr 4, 2017 #2 Hi, Perhaps something like this? Attached... First one is different, but all others are copy/paste. Hope this helps Attachments Book2.xlsx 11.1 KB · Views: 9
Hi, Perhaps something like this? Attached... First one is different, but all others are copy/paste. Hope this helps
B bosco_yip Excel Ninja Apr 4, 2017 #3 Similar to Pcosta's formula. 1] C3, copy down : =1&"-"&B3 2] E3, copy right to G3, I3, K3…...etc and copy down : =SUM($B3:C3)+(D3>0)&"-"&SUM($B3:D3) Regards Bosco Attachments SerialNumber.xlsx 11.6 KB · Views: 6
Similar to Pcosta's formula. 1] C3, copy down : =1&"-"&B3 2] E3, copy right to G3, I3, K3…...etc and copy down : =SUM($B3:C3)+(D3>0)&"-"&SUM($B3:D3) Regards Bosco
