cat

Hi there, I'm trying to work out how to create 2 different pivot tables from the one table. Here is an example table below: <tbody> Product Brand Category Jan Qty Jan Sales Feb Qty Feb Sales Mar Qty Mar Sales Item 1 Brand 1 Cat 1 5 $500 4 $400 7 $700 Item 2 Brand 2 Cat 1 20 $50 30 $75 10...

Looking for VBA to check if all data in a column is the same (text) - For example - if I did it manually -top row cell 1 would contain" '=IF(AND(B1=B2,B2=B3,B3=B4,B4=B5,B5=B6,B6=B7,B7=B8,B8=B9),TRUE,FALSE) But ideally I need this to just loop thru and check that all cols contain same text -...

I have the below data set and I need that information to complete the below table. The below data set is a small example, where you see Cat 1, Cat 2, etc - there are actually 30 of these. I need to fill in the below table, and need help creating the correct index, match or offset formula to...

In A1 i have: =INDEX(D2:D6,MATCH(LARGE(E2:E6,C2,E2:E6,FALSE)) This formula returns the top most valuable customer (dog). But there is a tie for second place (cat and amy) but it returns Amy Twice. How do i fix this? Ty <tbody> A B C D E Waffle 90 1 Dog 30 Amy 50 2 Cat 50 Amy 50 3 Amy 50...

Need help with a formula. I have 1 column. Lookup value in below chart would be "Cat" and I would it to return the cell right below, in this case "3". Thank you in advance!!! <tbody> Dog 6 Cat 3 Bird 2 </tbody>

Dear all, I am trying to find a formula that will return a value in the "Value" column in the small table to the right of the larger table. i.e next to cat 1 ref 129 should have a value of 182,500? Can anyone help? Thanks Chris <tbody> Cat 1 Cat 1 Cat 1 Cat 2 Cat 2 Cat 2 Cat 3...

Hello! Any guidance and help will be GREATLY appreciated! I have written out what I need (with examples) to give you a clear picture on what I'm trying to accomplish. I hope it helps. Scenario I have a "revenue forecast" sheet that shows Customer, Item, Quantity and Average Selling Price...

Dear All, Good Day. I need to return value in RESULT(E) which if CAT NUMBER 1(B) equals to SEARCH in CAT NUMBER 2(C:C) and needs to return respective cell in D , For example, IF B2=search(C:C) return value from D here the results for E2 is need to come SUCCESS PLEASE HELP ... <tbody> S.NO...

Hi all, I'm new to Pivot Tables ... and not sure if this is what I should be trying to use. To keep it simple, I have a List with two columns. 1. CAT 2. ITEM CAT has Hardware, Timber, Paint, Glazing etc... ITEM has many items using those Categories. How can I Pivot the list around so my CAT...

Greetings all, I have a table in Access 2013 that look like this: <tbody> Child Pet1 Pet2 Pet3 Pet4 Timmy Cat Dog Bird Rabbit Jimmy Dog Jack Cat Dog Bobby Cat Rabbit Todd Dog Bird </tbody> But what I would like is a table that looks like this...

Hello, I'm trying to find a formula that will help me to identify any dates that are overlapping by each Animal in column C. I have an example below where two lines of the cat and two lines of the mouse overlap so I would like an error message pointing out those four rows. Thanks! <tbody> C...

I am struggling to work out an average in a table with two conditions, I have tried averageifs and sumproduct and failed, please help. E.g. I want to know the average of all Cat that are in the UK only, which would be 3.33, or how many Man in China which should average 2. Please help with a...

good morning! I have a list on a worksheet (Registration) that contains information in the table below: (there are 4 people per hole) this spreadsheet will eventually have 40 holes or so, and 400ish people. P R S W X AB AC AG...

Hi guys, so i keep getting an error saying "Object variable or with block variable not set" the code used to work perfectly before i added something what i added was Set rng = Range(Range("A1"), Range("A1").SpecialCells(xlLastCell)) Set tbl = ActiveSheet.ListObjects.Add(xlSrcRange, rng...

Question should be straight forward. I searched and being a newbie didn't find a solution - at least one that I understood. Assume the table below. I would like count the number of unique numbers from the each of the names (Cat, Dog, Mouse). The real world problem is I have about 800,000 call...

Hello Could anyone tell me how I go about determining in Excel 2010 if a person named in Col A has any one of the Category Columns checked. I don't need to know if they've got more than one ie Mick has three checked. That's not important to what Im trying to achieve. I'm thinking its some kind...

I have one data source with multiple columns - for the purpose of this question, the column I'm concerned about is Category. The Category has several choices available - Cat 1, Cat 2, Cat 3, Cat 4, Cat 5, Cat 6 & Cat 7. I need to display scores from Cat 1, 2, 3 and 5 as a pie chart, so I have...