ROWS formula returns the number of rows in the given reference or array
Live Example here:
Free Excel Course –
Paid Online Training –
Best Excel Books:
⚙️ Gear I Recommend:
Camera –
Screen Recorder – techsmith.z6rjha.net/26D9Q
USB Mic –
Wireless Mic:
Lighting –
Subscribe to get awesome Excel Tips every week:
Note: Some of these links here are affiliate links!
#Excel #ExcelTips #ExcelTutorial
Watch more new videos about Excel Office | Synthesized by Mindovermetal English
thanx
hi, need your advise . I'm not familiar with excel formula. I'm trying to generate reference number. I have list of student approximate 600 student. I need to generate ref no, e..g FYP001 to FYP600… example
FYP project submission
1) Emma ( ID 8411) ( Assume at row B1)
2) Adam (ID14667) (B2)
3) ELLA (ID6477) (B3)
4) John
5) Pam
6) Dave
7) Devi
8) Chen
9) Lisa
10) cindy
..
250) Lynn
311) Jeff
470) Adam
511) Leela
600) Nathan B600)
How do i generate number e.g Ref No.
FYP001 at ROW 10 – Cindy
FYP002 at row 110
FYP003 at row 250
FYP004 at row 4
FYP005 at row 90…
need your advise