excelexcel-formulasequencecountif
How to create a Sequence number based on Sales Agent name and sale date in excel using formula
I am looking for a formula which can write the sequence no based on the criteria of Salesperson name and Sale order Date. below is the sample table. Please check if anyone can help me.
I tried using countif
=COUNTIFS(C$2:C2,"<="&C2,A$2:A2,A2)
but not getting the expected results as given in the image
Solution
This formula gives this result
=MATCH(B2,SORT(TOCOL(IF(A$2:A$8=A2,B$2:B$8,1/0),3),1,1),0)
- Putting Textboxes into array for formatting
- Code inserting and copying to the wrong worksheet
- convert a C# datetime object into Excel date format
- Get values from available column in a row to the first column of the same row
- VBA - Worksheet.activate not working
- Transform datatable from column-based to row-based
- Check for consecutive characters in an excel cell
- Add text to first available cell in range with non-contiguous cells
- Data Entry Transfer to Multiples Tables to Specific Sheets
- ExcelScript fails on webapp, succeeds on desktop
- Is there is Limition of using opencsv API or Apache Poi Api?
- How can I merge one excel datasheet with a master excel sheet with only some columns matching?
- How to access textBox placed on sheet in VBA module?
- Looking to create a copy of a document and copy data from Excel (words and tables) into it at bookmarks
- Only loop selected rows in Excel VBA
- How to pass multiple Excel sheets as data table when using ExcelDataReader?
- Combine most recent 5 records into one cell in Excel
- AutoFilter returning to 1st Range when trying to apply filter to different Range
- Importing Excel-tables in R
- Using Python, how to update an excel sheet on Azure Blob Storage while maintaining existing data in the sheet?
- Reorder sheet names in custom order
- Dynamic array using xlwings causing formula to be wrapped with {}
- Matching multiple number rows and check corresponding dates within 90 days
- Sum all cells for which corresponding cell is not a formula and doesn't return #VALUE AND date occurs in the past
- How can I use countif to return only a count if sum is > 0 but only count it once
- excel No of hours in a shift
- How to split a string into a 2-dimensional array in vba?
- Filter Range C3:G3 And paste to other cells
- How to solve Excel VBA: Compile error in hidden module
- Conditional Format Cells with Special Characters including Accented Letters, Numbers, and Punctuation