|
|
#1
10-25-2023, 01:50 AM
|
|||
|
|||
Count discounting products
Hello All,
Good Day! Hoping to get the function or formula for this one. We have a promo for a certain products that if you buy both Candy1(FRES CANDY under the "SUBBRANDNAME" on Excel file) and Candy2(KOPIKO CANDY under the "SUBBRANDNAME" on Excel file) you will get a discount. So I would just like to count or have a result of 1/avail per invoice. I already removed the duplicates on the Sheet2. Thank you. 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| count formula to count based on multiple criteria and return unique rows | Sphinxakop | Excel | 0 | 02-01-2023 12:18 PM |
 Why does the total row of my pivot table not tie to the real count using distinct count
|
wheddingsjr | Excel | 4 | 09-01-2020 09:52 PM |
| How do MS Office products link to URLs? | stegraham | Office | 2 | 10-22-2013 04:52 AM |
| All Office products stop working | lethlean | Office | 1 | 05-18-2013 07:07 AM |
|
FREE resources to learn M$ products...
|
zyzzyva57 | Office | 4 | 05-16-2009 07:31 AM |
Windows 10 
Office 2016
Threaded Mode