google sheetsgoogle-sheets-data-validation
I want to have auto numbering dependent on cell drop down box in helper column so i can sorted out.
If someone pick Start in A2 to have number 1 in B2.
Then if they skip one or two and chose Start A4 in B3=2,
A6 in B6=3
A3 in B3=4
Then auto sort the sheet based on B column?
https://docs.google.com/spreadsheets/d/1hu-NQ3QpeP-_SMwiSm3EY4uyVS36cswYrInOwgy7oP0/edit?usp=sharing
The data is there, but it's out of sight because of the blank rows that are included due to the use of whole columns (A2:B). Filter the rows where A or B cells are not empty. One way to do that is by using QUERY(), i.e.:
=QUERY({{'source data 1'!A2:B};{'source data 2'!A2:B}},
"Select Col1,Col2 Where (Col1<>'' OR Col2<>'') Order by Col1",0)
=ARRAYFORMULA(IF(A2:A19="",,IF(B2:B19="FFA",
D21/(COUNTIF(B2:B19,"FFA")+1.3*COUNTIF(B2:B19,"PB")),
D21/(COUNTIF(B2:B19,"FFA")+1.3*COUNTIF(B2:B19,"PB"))*1.3)))
Best Answer
Try this formula in cell B2:
We make use of the function ROW. ROW returns the row number of a specified cell..
Please read more about ROW here