dog

  1. I

    Condition formatting question.

    Hi, I would like to have certain text that I’ve selected from a drop down list certain font colours. Example. In the drop down list say I have Dog Cat Fish selections. When I select Dog from the list the font will be Red when Dog is then shown in that cell. Over time I will be able to look...
  2. N

    Vlookup with either two lookup value/Column

    <colgroup><col><col></colgroup><tbody> Column 1 Column 2 Chicken - Duck - Dog - Butterfly Snake - Pig - Ant </tbody> <colgroup><col width="64" span="2" style="width:48pt"> </colgroup><tbody> Table Chicken 10 Duck 20 Dog 30 Snake 40 Bear...
  3. G

    Return the column number of the nth occurrence in a row

    Hi, I couldn't find this answered exactly on the forum. Sorry if it has. I am looking to return the column number of the nth occurrence in a row. So in the example in the table below, I am looking to return the column number in row 1 of the 2nd (B4) occurrence of the word 'dog' (B3). In this...
  4. J

    How Good Are You?

    Solve this riddle if you would... Within A Table: Product Suggested Price Number Per Litter Dog 9.99 9 Cat 5.99 5 Bat 2.00 3 User clicks: "DOG" within the table That...
  5. V

    VBA to insert mutiple lines in the same celll

    Hello all I hope someone can help on this please I am looking for some VBA that will add lines into the same cell. In column "T" I have data that is followed by "," a comma then more data followed by "," a comma Example: dog, cat, horse What I need is dog cat horse but in the same cell...
  6. E

    Please help with Crosstab Query

    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...
  7. C

    Identifying Overlapping Dates Per Product

    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...
  8. Trevor3007

    Vlookup displays incorrect data

    hi I have a n issue with vlookup & even though I have checked the formula. If I but the same 'value' into a few lines it does not return the correct results ( except in the 1st line) Example:- Value (cell A1) vlookup (cell b1) vlookup (cell c1) dog sam...
  9. P

    average ifs

    Hi all I have a data sheet and a report sheet. (Data) I need the average (displayed in report column B) of the percentages in data column C, if the value in data column B matches the set values in report column A of results. Example: DATA: <tbody> A B C 1 Date Pet Result 2 2017-06-04...
  10. A

    Textjoin every three columns

    Hey Everyone, How do I textjoin every 3 columns? data is on one sheet, results on another. example below: Data sheet <tbody> Dog cat Fish Car Truck Plane </tbody> Results sheet <tbody> Dog, Cat, Fish Car, Truck, Plane </tbody> Thanks Andrew
  11. T

    Counting Duplicate Values Only Once in a Column B by Matching Criteria in Column A

    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...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top