My data looks like this:
("Albums" sheet)
Picture 1.png
("Sheet 2" sheet)
Picture 2.png
These are my codes:
=COUNTIF(Albums!AF:AF,"*"&A2&"*")
=AVERAGEIF(Albums!AF:AF,"*"&A2&"*",Albums!L:L)
The problem is that they don't compute "jazz" the way I want them to. I want to count and average *only* those albums that are specified as jazz, not the jazz fusion ones. I've tried and tried but haven't found any solution. Any suggestions?
So images are not the best way to go (Currently unable to see them)
Mind posting a sampling of your data and I or someone else here will be able to better assist in locating a solution for with you.
-If you think you are done, Start over - ELeGault
Not sure about the formatting, but:
Column A, Sheet "Albums"
Album
A Love Supreme
Kind of Blue
あらためまして、はじめまして、ミドリです。
Aghora
Column AF, Sheet "Albums"
Genre
Jazz
Jazz
Jazz fusion
Progressive metal, jazz fusion
Sheet 2
Genre Count Average
Jazz 4 3,93
Jazz fusion 2 3,52
Progressive metal 1 3,47
To attach a file to your post,
click advanced (next to quick post),
scroll down until you see "manage file",
click that and select "add files" (top right corner).
click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"
Once the upload is completed the file name will appear below the input boxes in this window.
You can then close the window to return to the new post screen.
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Here it is
Example.xlsx
I see - it would require knowing your data intimately. When using wildcards and having a variable char count or variations that are that close you will need to subtract out any that have the core within the other. It Cannot be (To my knowledge) be a single formula fits all in this case.
Than for your average base it on the results of counts, don't reapply the wildcard formula as to avoid further inflation of any counts.
I hadn't though of that. Tunnel vision, I guess.Originally Posted by ELeGault
It's actually a pretty decent solution - a huge improvement on what I'm working with now. Thank you very much - it's greatly appreciated.
One of those, sometimes the simplest solution is the right one -
If you are good with this - Don't forget to set the thread to SOLVED - Under thread tools-
Have a good one -
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks