Excel Help and Problems

[Therebbesbocher]

I'm trying to do a find and replace, but I only want to find the word in a specific format (color and shading) but when i try find format from cell it comes back with no results. Any ideas why this is?
TIA

[Der Deutsche Jude]

I'm trying to do a find and replace, but I only want to find the word in a specific format (color and shading) but when i try find format from cell it comes back with no results. Any ideas why this is?
TIA

are you using conditional formatting

[Therebbesbocher]

are you using conditional formatting

No, the list is copied from somewhere else and came with the color and shading

[yitzf]

I'm trying to do a find and replace, but I only want to find the word in a specific format (color and shading) but when i try find format from cell it comes back with no results. Any ideas why this is?
TIA

How do you know that you have the exact shade?

[Therebbesbocher]

How do you know that you have the exact shade?

That's why I'm using find format from cell, shouldn't it match it exactly?

[yitzf]

That's why I'm using find format from cell, shouldn't it match it exactly?

You copied it from another file, so how do you know that the color you are selecting on the find/replace is the same color as on the sheet. Maybe the sheet is a custom color etc.

[Therebbesbocher]

I think i got it, thanks for the help

[CountValentine]

I have 12345 in the first cell. I want every cell under it to increment 1 each time. Easiest way to do it? I need thousands.

[etech0]

Select A1. Click the Home tab, click Fill, click Series. Select Series In: Columns. Keep the Step Value at 1 and set the Stop Value to the number that you want to end with. Click OK.

[CountValentine]

Love the spoon feed instructions but it is not doing anything.

[yitzf]

I have 12345 in the first cell. I want every cell under it to increment 1 each time. Easiest way to do it? I need thousands.

If the first cell is A1, then B1 would be =A1+1. Then select B1 and you'll see a tiny box in the bottom right of the cell. Drag that down as far as you want.

[etech0]

Love the spoon feed instructions but it is not doing anything.

make sure you got every step?

[CountValentine]

If the first cell is A1, then B1 would be =A1+1. Then select B1 and you'll see a tiny box in the bottom right of the cell. Drag that down as far as you want.

That works. I am going down not across but works the same?

[etech0]

That works. I am going down not across but works the same?

Choose either 'rows' or 'columns' until you get the result you want. Otherwise if you select just that column it should work either way.

[yitzf]

That works. I am going down not across but works the same?

Works both ways but to go down the cell with the formula would be A2 and you would write =A1+1

[CountValentine]

make sure you got every step?

I select A1. It contains 12345
Home
Fill
Series
Columns
Enter Stop value: 100
OK
Did I miss anything?

[etech0]

The Stop Value needs to be the max value you want. So if you want 100 numbers, your stop value is 12445.

Over here it's not running at all since the stop value is lower than your start value.

(I made this same mistake a few times)

[CountValentine]

Thank you both. Works like a charm!!!

[etech0]

Thank you both. Works like a charm!!!

YW

[churnbabychurn]

For a series of even 20 cash flows from a non compounding loan payments (p&I)every two weeks, xirr is giving very different results then IRR*20

Is xirr giving the effective yield which is incorrect here because it's simple interest?