Filter Search Button

excelledsoftware · #16 12-13-2015, 10:30 AM

Quote:

Originally Posted by lonniepoet

That is even better! This is exactly what I need. This will allow for the other users to access the information way easier. However, I was recently given another task by management to add and calculate data for each SKU# being entered. They would like me to calculate the percentage of mistakes (per specific mistake) for each one. I added the fields they'd like to track and the sheet they'd like in order to get their "program summary report." I know how to do all the simple calculations, but how to I get the program summary report to track a total for each reason per each SKU# and not pulls sums/totals of the other SKUs? Any help would be much appreciated. Let me know if I should open up a new forum or something since this is a different issue. It could be seen as an added issue I suppose...

Lonnie, look into the formula SUBTOTAL (totals only the visible cells) and see if that will do what you need.

lonniepoet · #17 12-14-2015, 11:40 AM

I was tinkering with the subtotal formula, but I need it to only total the fields that are specific to each SKU# in column 'A'. For example, I need it to list all occurrences for "New Acct", "Damaged", etc. specific for 945DU2869 and so on. This spreadsheet will end up having over 1,000 entries when it is all said and done. Thank you in advance for looking into this.

charlesdh · #18 12-14-2015, 12:59 PM

Hi,

I was looking at the Report sheet. You have data in it that does not appear in "Log" sheet.
Columns "B" and "C". Where does that come from?

lonniepoet · #19 12-14-2015, 01:03 PM

The description (column B from report sheet) is something I was going to add after the fact. This will be an overall description of what each SKU# is and there will only be the 3 descriptions, so I didn't want to muddy the log sheet up. Column C on the report sheet is the same as the numbers list in Column C on the log sheet. However, I can just delete rows 2-5 on the log sheet now since this same info will be on the report sheet. My only issue was every time I delete the rows from the log sheet it messes up the button you did. Thank you.

charlesdh · #20 12-14-2015, 01:31 PM

Hi,

Modified the Log sheet. Also revamped the code for this. Take a look.
Also in the report sheet you are not concerned about the data in column "B"?
And too when I remove the rows in the log sheet the report now show "Ref".
Thats because I remove the rows.

lonniepoet · #21 12-14-2015, 01:43 PM

Charles, I had a COUNTIF function totaling-up all the occurrences of entries per each SKU# to give me a total of each entry in order to calculate the percentage of SKUs logged. I also need to calculate the total # of marked issues specific to each SKU#, but have been getting extremely confused. Thank you for helping me on this. Your work has been much appreciated.

charlesdh · #22 12-14-2015, 04:32 PM

Hi,

I'll try to put something together tomorrow. Was gone for a short time today.
We can address the "Countif" once I get the count for the "Problems" fiorthe report sheet.

lonniepoet · #23 12-14-2015, 04:35 PM

That would be much appreciated. Thank you for looking into this further for me. Hopefully, I am not a "problem". LOL

charlesdh · #24 12-15-2015, 01:13 PM

HI,

Are you wanting a separate button to run the "Report"?

lonniepoet · #25 12-15-2015, 02:50 PM

If a separate button works easier for you than you can. I just need the report sheet to calculate the totals and make the required percentages. It can just be a sheet that keeps a running tally to real-time or can be updated via a button. Honestly, this one can be your call. Whatever you think the most efficient way is. Thank you, Charles. –Lonnie-

charlesdh · #26 12-15-2015, 06:09 PM

Hi,

almost done. Have the counts going to the report sheet. All i need to do is the %.
Will not be done today. I'll be gone tomorrow. But, will finsh on thursday.

charlesdh · #27 12-16-2015, 12:31 PM

HI,

About ready to take off. For the % you have formula that looks at column "C" quality.
Where does that come from? Is it the count of the sku that you looking at?

lonniepoet · #28 12-16-2015, 01:00 PM

C4 is the total quantity of units being sold and I would like to divide column D (the total amount of replacements) from this in order to get the percentage of units needing to be replaced. Then, for each column (new acct, damaged, missing, etc.) this would divide into column C to give me a percentage for each issue by itself. Let me know if this makes since and thank you!

charlesdh · #29 12-17-2015, 12:24 PM

Hi,

In the file you sent I do not see "Number" of units being sold. Can you supply this info?
I have the code working to populate the Report. But, as mention I also need the quantity of units.

lonniepoet · #30 12-17-2015, 12:33 PM

Number of units sold is the same at column C "QTY." Sorry about this.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Onenote 2013 search is not identifying search terms correctly	Delta223	OneNote	0	08-12-2014 06:40 AM
Search for date and then apply mutliple search criteria in huge dataset	maxtymo	Excel	2	12-01-2013 04:52 AM
Looking for Windows Search app with ability to search by content	gopher_everett	Office	1	02-28-2013 09:23 PM
Instant Search's "Display search results as I type when possible" with Exchange	lwc	Outlook	0	06-01-2011 01:56 AM
Search and Replace - Clear Search box	JostClan	Word	1	05-04-2010 08:46 PM