Hi Frans You are correct about 101-111. They ignore filtered and hidden rows (including rows you set the height to 0) Sunny
What you ask and what you attach is very different. Your attachment only ask for invoice not paid.
Hi Tim I would highly recommend that you follow Frans advice. You can see my attachment that uses macro but the codes are quirky and not perfect...
Hi You can try adding a blank row above your table and put the dates (formulas) there. Data table does not allow formulas in the header. Hope th...
Hi Frans Without seeing the data, I can only make a guess. There can be many ways to handle the situation and your's may also work. Since she me...
Hi Rachel Both VLOOKUP and INDEX/MATCH can be use depending on the setup of the data on your 2nd spreadsheet. VLOOKUP can only find values to th...
Hi David You can modify to suit your needs. Just remember that the 1st row must be the delivered value e.g. cells D4, D16 etc Otherwise the form...
Hi David Thanks for your feedback and compliments By helping you, I have also learned a thing or two. Otherwise I wouldn't have even look at suc...
Hi Linda When you amended the data in your worksheet, you should have also amended the same in the ticketing system. This will then allow you to...
Hi David See if this will work. It needs a helper column. Just make sure that the 1st row is the delivered value e.g. cells D4, D16 etc. It can ...
Hi David I have looked at reshuffling the data and even separating them into different sheets (may not be practical as you may have many customers/...
Here I have a diagram for you.
Hi David These formulas does not work by just copying them to another cell. This is what you can do: 1) Let's say you copy the formula from c...
Hi David Maybe you can give as many scenario as possible in your example with the expected result (very important). I didn't quite understand th...
Hi David Give this a try. Hope this helps. Sunny