Nothing attached
Hi Howard How many rows of data will you have in the workbook on an ongoing basis? I think it will be easier to manually match off if the transaction ...
Not sure what you mean by the range needs to be fully flexible? This seems to work, using an expanding range so you need to drag down column D =...
Hi So as an example if i changed all the Column Assays for march to something else (bob) and then selected Column in the drop down you get #div/0! ...
Hi Shafiq Try this - it looks in each cell in column c and if its an error it deletes it - a word of warning it will delete the entire row if the c...
If you need the formula in excel to make it text you can use =LEFT(REPT("0",9-LEN(B2))&B2,3)&"-"&MID(B2,LEN(B2)-5,2)&"-"&RIGHT(...
Afraid not. There are formulas that will do simular but can be fairly complex. Depending how often you will be doing the filter you can just use no...
Seems to work for me What version of excel are you using? Filter is only availible in Office 365
Can you please add an example workbook so we do not need to recreate? Purfleet
Hi Can you please add an example workbook so we don’t need to recreate the data. Maybe a little bit more explaining the issue as well might help Pur...
I dont think you can use the find/replace in that way as it only finds and replaces. Pretty sure you will need to test each cell and then colour it...
I think the -- & * are a force of habit, but fair point. I assumed the duplication was somthing like that but it didnt seem to happen on anythi...
Mi Maria It looks like row 11 has been duplicated in your sumsif in row 14. But then the sum product you had was doubling the first 3 rows which wa...
Just panicked then as we had different totals until i noticed you used Column C in the table (Column E in Excel) and i used column C in Excel which is...
I was convinced i replied to this yesterday, must have forgot the submit. Yes sumifs ifs the perfect formula