Hi Jihad Saleh Alhalabi, welcome to Mynda's Forum! Since you are already using the average function in row 3 and you seem to want the outcome of yo...
Welcome to Mynda's Forum Blake! As I understand your explanation, you have to use the Vlookup in this Description field. It's better when you s...
Glad we could help and sorry Purfleet I caused a panic 🙂 Frans
Hi Ahmed, I think the sumifs is the solution for you for this question. Here your file with two calculations: one 'handmade' (dates) and one ref...
Thanks Anders! We will use the conditional formatting, that's a good idea. The 'choose' text gives the Red cell and maybe that will trigger the user t...
So this is a PowerPoint question rather then an Excel question? I tried it with a connection (obdc I think) but that didn't work out the way you in...
Sorry Mynda I owe you my apologies. Because I first didn't believe you with this answer. But I made a small example and tried it out myself and saw...
Hi Wayne, can you explain your Excel-file in combination with the text you wrote? I don't see the connection between those two? So maybe in the fil...
Creative and nice solution Anders! Works perfect and als with deleting or adding rows (where indeed you sometimes have to adjust the helper column, bu...
Thanks very much Anders. I see and think I understand why this is working and the original table not. Problem is that for this small part of data colu...
I was able to 'translate' the given formulas to the original table and it works without the CTRL-SHIFT etc. I handed it over and am waiting for the...