Jul 02 2018 03:09 AM
I have a set of data in excel sheet. I have filtered the data as I want. How can I number serialy these filtered data.
Jul 02 2018 04:27 AM
Jul 02 2018 04:38 AM
Hi Jamal,
This approach allows the sequential number to show dynamically.
Jul 02 2018 05:43 AM
Jul 02 2018 06:00 AM
Jul 02 2018 06:10 AM
does it can be done through MAX function. please download the attachment and view. I want to do like this
Jul 02 2018 06:32 AM
That only works with SUBTOTAL or AGGREGATE as Wyn suggested - apply formula before filtering and numbers will be recalculated upon each filtering
Jul 02 2018 07:18 AM
yes i got it..=MAX($j$1:j3)+1, where j is the column name. and 3 is the nmber just before the data begins
Jul 03 2018 07:12 AM
But that doesn't work with filtered rows
Jul 03 2018 07:50 AM
Jul 03 2018 08:24 AM