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