Hi,
I'm afraid i've reached the limit of my understanding in Excel and in need of some help.
Basically i have a trend analysis that takes information from 20 worksheets (5 per week over 4 weeks) within a workbook. At the end of the week i have a weekly report that (stupidly) requires a different trend analysis that gets sent off to the bosses in the format they want it - not the better format we have, but i digress.
Long story short, I need the weekly report, more specifically a single cell to look at 5 cells within the trend analysis. If any of those 5 cells have a ' ü ' in it then the cell in the weekly is to show a 1 to denote this was achieved in week one.
I have managed to learn a lot to make my trend analysis show what i want it too based on the information in the 5 reports within a week. However, this one is testing my abilities and winning so far. What i have been using follows, but doesn't give me the true solution i need.
In Cell within weekly report
=IF('Trend Analysis'!$U7:$Y$7 = "ü", "1", "")
You'll notice that i'm using the wingding font for a (tick), similar to the problem above, I also cant figure out how to get the trend analysis to not insert the "ü" and insert a O. If anyone can help with that, you'll be an absolute star!
Thanks in advance for any hints or tips.
C
I'm afraid i've reached the limit of my understanding in Excel and in need of some help.
Basically i have a trend analysis that takes information from 20 worksheets (5 per week over 4 weeks) within a workbook. At the end of the week i have a weekly report that (stupidly) requires a different trend analysis that gets sent off to the bosses in the format they want it - not the better format we have, but i digress.
Long story short, I need the weekly report, more specifically a single cell to look at 5 cells within the trend analysis. If any of those 5 cells have a ' ü ' in it then the cell in the weekly is to show a 1 to denote this was achieved in week one.
I have managed to learn a lot to make my trend analysis show what i want it too based on the information in the 5 reports within a week. However, this one is testing my abilities and winning so far. What i have been using follows, but doesn't give me the true solution i need.
In Cell within weekly report
=IF('Trend Analysis'!$U7:$Y$7 = "ü", "1", "")
You'll notice that i'm using the wingding font for a (tick), similar to the problem above, I also cant figure out how to get the trend analysis to not insert the "ü" and insert a O. If anyone can help with that, you'll be an absolute star!
Thanks in advance for any hints or tips.
C