# Tagged Questions

**-1**

votes

**1**answer

34 views

### Conditional Formatting from Helloh, for a Noob

I'm going to try my best to explain what I need to figure out. Also, for you to understand exactly how mind bending this is for me, I haven't used an Excel formula since 2005/2006ish. We're doing a ...

**0**

votes

**1**answer

286 views

### CONDITIONAL FORMATTING for First SIX characters, ALL duplicates Highlight

How do I use CONDITIONAL FORMATTING for the First SIX characters ? I want ANY and ALL duplicates of the First SIX Characters highlighted.
I need a formula but cannot figure out what formula to ...

**0**

votes

**2**answers

149 views

### How can I check cells for number series?

I have a bit of a problem evaluating an excel cell. Example:
M M M M M M M M M
1 2 3 4 5 6 7 8 9
2;5;7
1;9
3;5;7;9
I have a number of excel ...

**2**

votes

**2**answers

3k views

### Excel VBA Function for Value AND Format Lookup

I need a custom function to lookup both a cell value and copy the source format. I have a list of values in two columns. The first is of integers and the second column is the corresponding text ...

**0**

votes

**1**answer

215 views

### Excel: is it possible to extract a superscript letter from a word?

I'm wondering if these is a way of using a formula to find a superscript letter, rather than just the last letter of a word.
I have lots of tabs, with nearly matching tables on each one showing up to ...

**0**

votes

**1**answer

684 views

### Excel Macro: compare separate workbook lists and LINK to the data in a corresponding column?

1. How can I compare two matching lists from separate workbooks? And then retrieve the data from the same row but another column - (Index&Match maybe be appropriate for this). But how does this look ...

**0**

votes

**2**answers

598 views

### excel - merge cells including a zip code

I have the need to merge a bunch of cells that comprise an address (street, city, state, zip) into a single cell. No problem except with the zip code.
The zip cell has only 4 digits for any zip ...

**0**

votes

**2**answers

1k views

### Specify formatting information in Excel forumla

Is there a way to specify the formatting in an excel formula?
=IF(A1="Large","This is BIG","This is small")
Where "BIG" is of a font size larger than the text for "small"?
(I'm aware of ...

**0**

votes

**3**answers

17k views

### Excel 2007 formulas not autofilling when I drag down

If you write a formula like:
=sumproduct((something=$A1)*(somethin=$B1))
Giving a result of 8. Usually the references and results change as you drag it down into other cells. Well,the references ...