I think this has to do with the TEXT function, not being able to use it for a range (ie E1:E7). In your column D the function refers only to one cell ...
Sounds like a little bug. I can't reproduce it, here it's working fine. Maybe you can upload a little sample file, so we can check what happens wit...
Can't find the attachment Jim, please try uploading again. Frans
I tried this in the sample and it works. However when you copy that new data from column say I to column C and paste it as values, the dates in the ce...
Hi Nur, welcome here on Mynda's Forum. I examined your file and see two things: 1) You stated you inserted a drop down menu with three options i...
Hi Sathish welcome on Mynda's Forum. Do you want to make a chart of the 8 groups? So 8 values. Or do you want to make a chart of the answers of all qu...
I'm afraid it's more complicated than you suppose Alan. Maybe the easiest way is to make a helper column right of column B. In that column (you can hi...
Hi David. I think this can be done by VBA, but that's not my cup of tea. Seeing your example I was thinking about a pivot table and then make a report...
Hi Alan, I don't know how sophisticated you want this, but a simple solution might be working with a conditional formatting in column B. In your ex...
Try attaching the file again Madi J, can´t find it now! Frans
Hi Zhanekesh, welcome with your first question here. I found some solutions and put them in your sheet in new columns. You can see which formula I ...
Hi Alan, when I put a number in AF21 it counts in AF1, as you also discovered. When I then delete the number in AF21, it still counts the value in AF1...
Well the number is the matching point for the Vlookup, but I can't follow you in what comes from one source and what from the other and what you want ...
Hi Lea, The outcome in J1 is TRUE or FALSE. So in your conditional formatting you have to take that and not 1 and also not text quotes or so. Th...
Thanks boys! Nice to keep on learning here! Frans