- My Forums
- Tiger Rant
- LSU Recruiting
- SEC Rant
- Saints Talk
- Pelicans Talk
- More Sports Board
- Fantasy Sports
- Golf Board
- Soccer Board
- O-T Lounge
- Tech Board
- Home/Garden Board
- Outdoor Board
- Health/Fitness Board
- Movie/TV Board
- Book Board
- Music Board
- Political Talk
- Money Talk
- Fark Board
- Gaming Board
- Travel Board
- Food/Drink Board
- Ticket Exchange
- TD Help Board
Customize My Forums- View All Forums
- Show Left Links
- Topic Sort Options
- Trending Topics
- Recent Topics
- Active Topics
Started By
Message
Posted on 4/23/19 at 2:58 pm to tylercsbn9
quote:I understood that. My question was won't I need to do a search for each unique abbrev/word in A (not each instance of that word but a search for each unique word). There are hundreds of different words in A.
Then he should use two characters instead of three and group the pivot table appropriately as needed. Although I am guessing this will go right over his had since they don't even have a very basic understanding of excel.
Posted on 4/23/19 at 2:59 pm to The Mick
Your computer just needs more ram.
Posted on 4/23/19 at 3:03 pm to Blueprint
There's an excel guru from the Money forum that will probably be looking for a new job soon. Hit him up, he'll probably be working at your nearest McDonalds
Posted on 4/23/19 at 3:07 pm to The Mick
quote:
I understood that. My question was won't I need to do a search for each unique abbrev/word in A (not each instance of that word but a search for each unique word). There are hundreds of different words in A.
It is pretty hard without having your data or exactly what your end result needs to be.
How many different abbreviations do you need total results for?
I imagine something like this would be the end result.
You can then take the data field out to make it cleaner.
>
This post was edited on 4/23/19 at 3:09 pm
Posted on 4/23/19 at 3:15 pm to tylercsbn9
OP..you could ask (or pay) somebody to do this and they could have it competed for you in about 10 minutes. What you want is simple but only you have the data to filter and know what you want.
Just email me the file along with the id/pin to your PayPal account and I get this to you within the hour.
<----- @gmail.com
Just email me the file along with the id/pin to your PayPal account and I get this to you within the hour.
<----- @gmail.com
Posted on 4/23/19 at 3:16 pm to tylercsbn9
quote:probably 100-125'ish.
How many different abbreviations do you need total results for?
Posted on 4/23/19 at 3:17 pm to Crow Pie
quote:Can I blow you as form of payment?
Just email me the file along with the id/pin to your PayPal account and I get this to you within the hour.
Posted on 4/23/19 at 3:18 pm to The Mick
Just create an abbreviation column with the left formula in a new column and pivot the whole data range.
My last post with pictures will work whether you need 5 abbreviations or 500.
The pivot table will do 99% of the work for you. Those values under total will equate to the summation off all results that start with ax, bh, dB, etc in your data set
My last post with pictures will work whether you need 5 abbreviations or 500.
The pivot table will do 99% of the work for you. Those values under total will equate to the summation off all results that start with ax, bh, dB, etc in your data set
This post was edited on 4/23/19 at 3:23 pm
Posted on 4/23/19 at 3:19 pm to The Mick
Pivot table or sort on column A and then do subtotals
Posted on 4/23/19 at 3:52 pm to tylercsbn9
quote:I will give this a shot.. appreciate all your help for realz
Just create an abbreviation column with the left formula in a new column and pivot the whole data range.
My last post with pictures will work whether you need 5 abbreviations or 500.
The pivot table will do 99% of the work for you. Those values under total will equate to the summation off all results that start with ax, bh, dB, etc in your data set
Posted on 4/23/19 at 4:10 pm to The Mick
Pivot table is the answer but if sorted on column A, and IF statement can be used to sum column B when A changes to the next new value.
Posted on 4/23/19 at 4:15 pm to The Mick
quote:
Can I blow you as form of payment?
I'm in
quote:
Pivot table is the answer but if sorted on column A, and IF statement can be used to sum column B when A changes to the next new value.
When yall stop pussy pivoting around in Excel, he can email me his data sets and I'll write a quick sql cursor to feed column A every possible abbreviation and spit out the grouped and summed totals(he will swallow) back in Excel.
This post was edited on 4/23/19 at 4:18 pm
Posted on 4/23/19 at 4:16 pm to The Mick
quote:
Sort the column in question and it will place all cells with like characters next to each other
And then...?
Add subtotal for every change in column A.
Posted on 4/23/19 at 4:16 pm to mikelbr
quote:
Can I blow you as form of payment?
quote:
I'm in
sigh, just like clockwork
Posted on 4/23/19 at 4:19 pm to 777Tiger
quote:
sigh, just like clockwork
Read the edit. I am actually a very experienced analyst and dba.
I could do this shite in my sleep using SQL but accountants and sales dorks get cute and try to do everything in Excel pivot tables.
This post was edited on 4/23/19 at 4:21 pm
Posted on 4/23/19 at 4:29 pm to The Mick
=sumif(all info in columnA, value in columnA you want, all info in columnB)
Posted on 4/23/19 at 4:54 pm to The Mick
Sort on column A then use summation on cllum b.... That would be easiest.
Or you could get in to some if-then statements. But that seems unattainable for you.
Or you could get in to some if-then statements. But that seems unattainable for you.
Posted on 4/23/19 at 5:11 pm to 777Tiger
quote:
sigh, just like clockwork
I believe you, uh, used one too many ells.
Popular
Back to top
Follow TigerDroppings for LSU Football News