-1
votes
1answer
35 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
1answer
360 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
2answers
153 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
2answers
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
1answer
218 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
1answer
690 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
2answers
613 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
2answers
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
3answers
19k 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 ...