Neilp Posted May 29, 2014 Share Posted May 29, 2014 Hi, I'm looking for some help with a formula for a spreadsheet i'm producing. I'm limited in skill and got to a point where I need a spreadsheet to auto-accumalate. I'm unsure how to give text a numerical value, and then based on the text- a total to be accumulate per column as a numerical value. Any help would be appreciated and if it helps I can forward a copy of the document i'm trying to produce. Cheers Neil Quote Link to comment Share on other sites More sharing options...
Neilp Posted May 30, 2014 Author Share Posted May 30, 2014 Anybody? Quote Link to comment Share on other sites More sharing options...
Stutopia Posted May 30, 2014 Share Posted May 30, 2014 pm sent Quote Link to comment Share on other sites More sharing options...
spursmaddave Posted May 30, 2014 Share Posted May 30, 2014 I don't use numbers but if your stuck email me the file and I will have a look matey, could do with a break from the 15,000 weekly hr rosta I have been working on..... oh wait hang on Quote Link to comment Share on other sites More sharing options...
spursmaddave Posted May 30, 2014 Share Posted May 30, 2014 If it is any help in excel there is text to column of value(x) to get a numeric value from a string Quote Link to comment Share on other sites More sharing options...
Stutopia Posted May 30, 2014 Share Posted May 30, 2014 Would a nested IF statement suffice, if the variety of text options in the column wasn't too broad? Quote Link to comment Share on other sites More sharing options...
spursmaddave Posted May 30, 2014 Share Posted May 30, 2014 Would a nested IF statement suffice, if the variety of text options in the column wasn't too broad? All depends doesn't it, lots of ways to go about it, all right if you get the correct result Sent from the golf club... 1 Quote Link to comment Share on other sites More sharing options...
Stutopia Posted May 30, 2014 Share Posted May 30, 2014 Would a nested IF statement suffice, if the variety of text options in the column wasn't too broad? All depends doesn't it, lots of ways to go about it, all right if you get the correct result Sent from the golf club... That's why Bill invented hidden "helper" columns Quote Link to comment Share on other sites More sharing options...
spursmaddave Posted May 30, 2014 Share Posted May 30, 2014 Would a nested IF statement suffice, if the variety of text options in the column wasn't too broad? All depends doesn't it, lots of ways to go about it, all right if you get the correct result Sent from the golf club... That's why Bill invented hidden "helper" columns Help? That is a new concept to me Sent from the golf club... Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.