I am so going to kill my sister.
-
She'll probably beat him up anyway. :laugh:
Join the cool kids - Come fold with us[^]
-
She'll probably beat him up anyway. :laugh:
Join the cool kids - Come fold with us[^]
-
Two weeks I have been struggling with a problem that she had. She had a large spreadsheet and and wanted a count based upon contents of several columns. This was the cell entry to do the count...
{=COUNT(IF(Biggleswade!$A$2:$A$2981='Control Sheet'!$AE7,IF(Biggleswade!$H$2:$H$2981>0,Biggleswade!$H$2:$H$2981)))}I was trying everything, summing, changing columns, adding conditions, the lot. I made my own spreadsheets and tried and it worked. Then, about 5 minutes ago, it the scales fell from my eyes and I had it solved! The column$A$2:$A$2981wasn't numbers! It looked like numbers but it was F***ing Text! All solved. I rang her and told her it was done. Then promised to come round hit her with a big stick.------------------------------------ I will never again mention that I was the poster of the One Millionth Lounge Post, nor that it was complete drivel. Dalek Dave CCC League Table Link CCC Link[^]
Noob.
Wout
-
And? We knew that already, she is a Dalek after all. :confused:
Luc Pattyn [Forum Guidelines] [Why QA sucks] [My Articles] Nil Volentibus Arduum
Please use <PRE> tags for code snippets, they preserve indentation, and improve readability.
-
Dalek Dave wrote:
She is my prodigy, I am teaching her, so I can beat my padawan from time to time!
Surely you mean "protege" :doh: :)
-
Noob.
Wout
I don't think he is a noob to Excel. It's a common oversight with Excel. You always have to be aware of the formatting of your data in a spreadsheet. It happens to me all the time and I use Excel everyday to perform analysis.
-
Two weeks I have been struggling with a problem that she had. She had a large spreadsheet and and wanted a count based upon contents of several columns. This was the cell entry to do the count...
{=COUNT(IF(Biggleswade!$A$2:$A$2981='Control Sheet'!$AE7,IF(Biggleswade!$H$2:$H$2981>0,Biggleswade!$H$2:$H$2981)))}I was trying everything, summing, changing columns, adding conditions, the lot. I made my own spreadsheets and tried and it worked. Then, about 5 minutes ago, it the scales fell from my eyes and I had it solved! The column$A$2:$A$2981wasn't numbers! It looked like numbers but it was F***ing Text! All solved. I rang her and told her it was done. Then promised to come round hit her with a big stick.------------------------------------ I will never again mention that I was the poster of the One Millionth Lounge Post, nor that it was complete drivel. Dalek Dave CCC League Table Link CCC Link[^]
This has happened to me a number of times, especially if there is a lot going on in my spreadsheet and I have different formatting involved with my data. What's great is that you solved the problem and now you are going to beat her senseless with a big stick. +5 :-D I know you don't celebrate Thanksgiving but have a good Holiday season anyways.
-
Two weeks I have been struggling with a problem that she had. She had a large spreadsheet and and wanted a count based upon contents of several columns. This was the cell entry to do the count...
{=COUNT(IF(Biggleswade!$A$2:$A$2981='Control Sheet'!$AE7,IF(Biggleswade!$H$2:$H$2981>0,Biggleswade!$H$2:$H$2981)))}I was trying everything, summing, changing columns, adding conditions, the lot. I made my own spreadsheets and tried and it worked. Then, about 5 minutes ago, it the scales fell from my eyes and I had it solved! The column$A$2:$A$2981wasn't numbers! It looked like numbers but it was F***ing Text! All solved. I rang her and told her it was done. Then promised to come round hit her with a big stick.------------------------------------ I will never again mention that I was the poster of the One Millionth Lounge Post, nor that it was complete drivel. Dalek Dave CCC League Table Link CCC Link[^]
Dalek Dave wrote:
It looked like numbers but it was F***ing Text!
What was the text, a six?
I wanna be a eunuchs developer! Pass me a bread knife!
-
Dalek Dave wrote:
She is my prodigy, I am teaching her, so I can beat my padawan from time to time!
Surely you mean "protege" :doh: :)
With DD who knows? :laugh:
-
Two weeks I have been struggling with a problem that she had. She had a large spreadsheet and and wanted a count based upon contents of several columns. This was the cell entry to do the count...
{=COUNT(IF(Biggleswade!$A$2:$A$2981='Control Sheet'!$AE7,IF(Biggleswade!$H$2:$H$2981>0,Biggleswade!$H$2:$H$2981)))}I was trying everything, summing, changing columns, adding conditions, the lot. I made my own spreadsheets and tried and it worked. Then, about 5 minutes ago, it the scales fell from my eyes and I had it solved! The column$A$2:$A$2981wasn't numbers! It looked like numbers but it was F***ing Text! All solved. I rang her and told her it was done. Then promised to come round hit her with a big stick.------------------------------------ I will never again mention that I was the poster of the One Millionth Lounge Post, nor that it was complete drivel. Dalek Dave CCC League Table Link CCC Link[^]