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

  • JAMAL MUHAMMED A's avatar
    JAMAL MUHAMMED A
    Copper Contributor
    Jul 02, 2018
    Without filtering how can i do this
    • Wyn Hopkins's avatar
      Wyn Hopkins
      MVP
      Jul 02, 2018
      Sorry I don’t understand what you mean

Resources