It never ceases to amaze me the solutions I find in these forums. I fin
I;m posting about a question a week, and I have gotten some absolutel
amazing answers. If one of you who have helped me before happens t
come across this post as well, I just wanted to take a moment and sa

I have a list of 1000 items in Row A. I have a list of key words in ro
C see below
C1   Dog
C2   Cat

I have 2 differnent lists of names each with their corresponding sales.
What I want to do is output a new list that has paired the people in the
different lists that have similar sales (+/-500):confused:

Thanks for reading this post.
I have a range of 2000 sets of data. I am trying to find the average
age of this set of  employees when they were hired. The employees age
is within Column G, their hire date is in Column H, and the date the

If I have a ton of phrases listed, some singular and some plural form in
separate cells of one column, listed like below, is there a way to delete the
plural versions quickly and keep the singular without spaces inbetween the
cells (where the plural forms used to be)?  If it ...

I'm creating a workbook and have inserted a Combo box. I would to be able to
view certain information every time I change the option from the combo box. I
have tried with Validation option and Drop list but can not seem to find the
formula. I have done this before in another ...

I went into Page Setup-It's set to adjust to 60% normal size and then the
item under that is Fit to 1 page wide by ____tall.  Is this right?

I have one sheet and I have numerous automatic page breaks.  How do I get rid
of them?

I have about 1000 cells in one column full of singular form text (all various
phrases and words) that I need to copy into the next column over, and change
into plural form.  Is there a function that can quickly do this?

I have the following in columns a and b:
_A__B_
Jan|  1  |
Feb|  2  |

Can someone translate the following IF statement for me?
=IF((A2<>"")*(ISNA(MATCH(A2,$A$1:A1,0))),"A","B")
I'm confused abut the first part, specifically the asterisk separating the
two criteria.  

I am trying to lookup two values using vlookup and I want it to return one
value.  I have tried at least three of the solutions posted on this forum.  
None works.
My data is on tab 'Formulae' as follows from Row 36 to 63. Sample as shown

I clicked on the row that  I didn't want to print, went to file-print
area-clear area.  It still prints.  Is there another method I could use?

I have the following function.  I'm trying to say that if it is before
12:00 pm, say "Good Morning," if after 12:00 pm but before 6:00 pm say
"Good Afternoon," and otherwise say "Good Evening".  The function
however, is not working properly.  Any ideas?

Is there a limit to the number of macros you can record in a file, i keep
getting a message come up that says "unable to record "