Sounds like you need some kind of look up. Can you attach an example worksheet so we can see where everything is?
Depends what version of excel you are running - Office 365 or 2019 you can use Textjoin and it is perfect for what you are asking Older version...
So you want a template created for each Souce & day? This would be invoice 1 (99909900 for the 01/01/2020) Date Item Code Item Name ...
Doing =RIGHT(E5,8) on column E is not returning the time in a format excel can recognise. Try =TIME(HOUR(E5),MINUTE(E5),SECOND(E5)) and your maxifs wo...
Can you provide an example of what you are looking for and where the data is held with in the workbook?
Can you supply some sample data? Much easier to work out a fix if we can see what you have to start with.
Hi Nambiar Not sure i really understand your data. Are you saying that if column G is blank it is incomplete - so you could just filter on G for bl...
Strange spreadsheet! The first 2 days in columns B to E dont have an overtime column, but the other 4 do - is this an error or by design? I real...
Hi Cindy Looking at your data the simplest way would be to create a pivot table and then drag in Customer Name and Product purchased - See sheet 2 ...
Purfleet said The reason the first table changes is becuase rows 7 & 10 are static, so if you re-sort, the max is still looking at rows 7 & 1...
Just got in to work where we have Excel 2016 and Max and If [=MAX(IF(Tabel23[man/woman]="W",Tabel23[Help],FALSE))] does work. Also the Index and Ma...
The reason the first table changes is becuase rows 7 & 10 are static, so if you re-sort, the max is still lookig at rows 7 & 10 which change d...
How about this in column D, gives you the number of days =IF(ISNUMBER(SEARCH("Week",C8))=TRUE,LEFT(C8,2)*7,IF(ISNUMBER(SEARCH("Month",C8))=TRUE,LEF...
I have only used ActiveX controls in a few macros where i wanted the extra functionality. Normally i would just add buttons to run a particular par...
Glad it was okay, could be made more efficent but as long as it works okay it will give you a start. What is the issue with the delete part you men...