Hello,
Can someone help me out of these.
As attached. I want C4 to list down the Serial No. by date range.
Ty in advanced.
Hello,
Can someone help me out of these.
As attached. I want C4 to list down the Serial No. by date range.
Ty in advanced.
Last edited by pakida; 08-29-2018 at 10:26 PM.
Thanks for the title change.
Try array entering this in cell C4 of 'Sheet1'. If you aren’t familiar with array-entered formulas array enter means the formula must be committed from edit mode by simultaneously pressing and holding down Ctrl and Shift while hitting Enter.
Formula:Please Login or Register to view this content.
Also:
Your profile says Excel 2003. The upload is a newer format.
Please update your profile to reflect what version(s) you are using. Members tailor solutions with that in mind. In this case there are other solutions that won't work in 2003.
Dave
Thank you for your help. Sorry I didn't notice my profile since I'm using another PC. Will change soon.
You are welcome. Thank you for the feedback and added rep.
Does the formula do what you want with the real data?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks