Hi Team,
Need your help to sort Entire Data as per Invoice Date Column.
But Invoice date Columns are All not in Complete Date. plz help . Thanks
Below is a Data. sort data as per Criteria from Column A.
Thanks
mg
Need your help to sort Entire Data as per Invoice Date Column.
But Invoice date Columns are All not in Complete Date. plz help . Thanks
Below is a Data. sort data as per Criteria from Column A.
Book2 | ||||||
---|---|---|---|---|---|---|
A | B | C | D | |||
1 | Invoice Date | ISNumber | data1 | Data2 | ||
2 | 10/12/2020 | TRUE | xxx | yyy | ||
3 | 10/12/2020 | TRUE | xxx | yyy | ||
4 | 10/12/2020 | TRUE | xxx | yyy | ||
5 | 13/06/2019 | FALSE | xxx | yyy | ||
6 | 13/08/2020 | FALSE | xxx | yyy | ||
7 | 13/08/2020 | FALSE | xxx | yyy | ||
8 | 13/08/2020 | FALSE | xxx | yyy | ||
9 | 13/10/2020 | FALSE | xxx | yyy | ||
10 | 13/10/2020 | FALSE | xxx | yyy | ||
11 | 13/10/2020 | FALSE | xxx | yyy | ||
12 | 14/10/2020 | TRUE | xxx | yyy | ||
13 | 13/10/2020 | FALSE | xxx | yyy | ||
14 | 13/10/2020 | FALSE | xxx | yyy | ||
15 | 11/10/2020 | TRUE | xxx | yyy | ||
16 | 13/10/2020 | FALSE | xxx | yyy | ||
17 | 13/10/2020 | FALSE | xxx | yyy | ||
18 | 13/10/2020 | FALSE | xxx | yyy | ||
19 | 13/10/2020 | FALSE | xxx | yyy | ||
Sheet1 |
Cell Formulas | ||
---|---|---|
Range | Formula | |
B2:B19 | B2 | =ISNUMBER(A2) |
Thanks
mg