alliswell
Board Regular
- Joined
- Mar 16, 2020
- Messages
- 197
- Office Version
- 2007
- Platform
- Windows
- Mobile
I put name in F1 that i need to get listed from column B.
I am using this formula in G column and it lists the name only.
=IF(ROW(B1<=COUNTIF(B:B,$F$1),$F$1,"")
The date and other records are not coming with the name. Tried to add COLUMN formula to the above formula but giving error. Please help.
I am using this formula in G column and it lists the name only.
=IF(ROW(B1<=COUNTIF(B:B,$F$1),$F$1,"")
The date and other records are not coming with the name. Tried to add COLUMN formula to the above formula but giving error. Please help.