Forum Discussion

JAMAL MUHAMMED A's avatar
JAMAL MUHAMMED A
Copper Contributor
Jul 02, 2018

excel numbering in afiltered data

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.
Formulas and Functions
JAMAL MUHAMMED A's avatar
JAMAL MUHAMMED A
Copper Contributor
Jul 02, 2018
ie , I want to put the number 1,2,3....after filtering.
  • Wyn Hopkins's avatar
    Wyn Hopkins
    MVP
    Jul 02, 2018
    As far as I’m aware it’s not possible to drag down to fill a filtered list or auto populate it in sequence while filtered.
    It could probably be done with some VBA code.
    • JAMAL MUHAMMED A's avatar
      JAMAL MUHAMMED A
      Copper Contributor
      Jul 02, 2018

      does it can be done through MAX function. please download the attachment and view. I want to do like this

      • SergeiBaklan's avatar
        SergeiBaklan
        Diamond Contributor
        Jul 02, 2018

        That only works with SUBTOTAL or AGGREGATE as Wyn suggested - apply formula before filtering and numbers will be recalculated upon each filtering

Resources