wmfexcel

Apply Conditional Format for alternate row color based on groups… June 8, 2019 - (3)
…that works even when filter is applied. The situation: We have a table that we would like to apply color banding based on groups. We can achieve this by inserting a helper column to identify the sequence of each group, with the following formula: In C2, input =IF(A1=A2,C1,SUM(C1,1)) ‘copy down and then apply conditional formatting […]

Rate this:
Unstack uneven data across columns with #Excel #PowerQuery June 5, 2019 - (0)
Unstack data across columns with #Excel Pivot Table May 29, 2019 - (0)
Waterfall chart is just a few clicks away with #Excel 2016 May 18, 2019 - (1)
Split cell contents separated by line feed into rows with #Excel #PowerQuery – Part 2 May 13, 2019 - (5)

Mobile Site | Full Site