Hi
I am kindly asking for a formula to automatically capture invoice numbers from Sales Data to VAT Sheet. Please see the attached excel sample.
Thank you.
Regards,
Sunboy
Hi
I am kindly asking for a formula to automatically capture invoice numbers from Sales Data to VAT Sheet. Please see the attached excel sample.
Thank you.
Regards,
Sunboy
Based on your example
Formula:Please Login or Register to view this content.
Last edited by ChemistB; 08-18-2020 at 01:05 PM.
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
Please try at E2
=IFERROR(AGGREGATE(15,6,'SALES DATA'!$B$2:B9/(FREQUENCY('SALES DATA'!$B$2:$B$9,'SALES DATA'!$B$2:$B$9)>0),ROWS(E$2:E2)),"")
and change ISBLANK(E2) to E2=""
Or use Pivot table
Thank you for helping me. The formula is working well. What negative effect ISBLANK have on the above formula.
Thank you again.
Regards,
Sunboy
ISBLANK only returns TRUE for truly blank cells. If you use a formula to enter "", then it's not blank. "" is called a null set. On the other hand, if you use COUNTBLANK(A2), it counts "" as a blank. I don't know if COUNTBLANK is available in Excel 2010
Thank you for explaining ISBLANK, now I know where to use it or not.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks