|
|
Replace hard return with a delimiter? by
Erin.
I have an Excel 2003 file with the full US address in one column. Street and
city are seperated by a hard return as are state and zip. Ultimately I need
to...
|
|
3 |
161 |
|
|
SUMPRODUCT not working. by
Gaurav[_7_]
can someone please help me understand what is wrong with the following
formula?
=SUMPRODUCT((Sheet1!$C$2:$C$3515=A2)*(Sheet1!$B$2:$B$3515="-2"))
|
|
2 |
100 |
|
|
Cycle Times by
PAL
I am trying to calucate cycle times. I have 2 milestones (each with a
planned and actual date
Column A: Milestone 1 Planned
Column B: Milestone 1...
|
June 25th, 2009 09:31 PM
by PAL
|
4 |
128 |
|
|
Automatic Cell Copy to other worksheets by
sharice.g
I made payment sheets for my cheerleaders in order to track orders and
payments made. I have about 30 different worksheets in this one workbook.
Workbook...
|
|
1 |
92 |
|
|
Excel Comments by
lisa
The option to view comments in Excel by doing a mouse rollover seems to have
disappeared.
|
June 25th, 2009 08:42 PM
by lisa
|
5 |
105 |
|
|
forgoten password by
Leon
I have forgoten or mispelled my password. It keeps telling me that my caps
lock needs to be adjusted. I have done every possible spellings with caps.
So I...
|
|
4 |
108 |
|
|
lookup issue.... by
John
I am stuck...cant figure out whats wrong with this formula....any help???
=if(isblank(Data Sheet!E3,"1",'Data Sheet'!E3))
Also if i want to use the above...
|
|
2 |
108 |
|
|
Using tab key in protected worksheet by
bev
I have a worksheet that I am allowing users to edit only certain cells. In
the protected mode, the tab key won't work, only the arrows and enter key.
Any...
|
June 25th, 2009 07:35 PM
by bev
|
4 |
158 |
|
|
Conditional Count Formula by
Mully
If your up for a challenge please have a go at this formula as I'm stumped!
What I want to do is create a formula that will analyze a historical table
of...
|
|
3 |
136 |
|
|
how to use vlookup for more than 1line by
LHM
I have severeal lines for every invoice number. Vlookup formula just bring
the first line. I need a formula to bring all lines to my summary sheet.
|
June 25th, 2009 07:08 PM
by LHM
|
3 |
116 |
|
|
|
|
4 |
107 |
|
|
how to make a preforated page-break insert by
KoldKream
I'm trying to make a preforated page-break on a spreadsheet.
The preforated insert should show the "itty-bitty" cut lines where ever I
have the page-break...
|
|
2 |
89 |
|
|
Sorting Coloumns that are Formula's by
heritage1450
I have a set of data that I'm trying to sort. The data itself is coming from
a formula, but when selected the full set of data, going to Data Sort,
choosing...
|
June 25th, 2009 05:37 PM
by Eduardo
|
1 |
95 |
|
|
Woman age 40 by
Tony_student
Let's say one colomn is a list of different gender types (man, woman, man,
woman and so on) and another colomn a a list og ages (25, 35, 40, 35 and so
on)....
|
June 25th, 2009 05:34 PM
by JLatham
|
9 |
125 |
|
|
|
|
2 |
90 |
|
|
|
|
0 |
91 |
|
|
i need some help in a type by
Vatos
i have the first name o people in a row of names, and i want a type to check
if the second to last letter is "η" then write the name without the last...
|
|
2 |
81 |
|
|
Merge two columns of data with a condition by
Richard
Hello,
I am trying to put information that is in two columns into a third column,
but I don't the two columns concatenated. If the same information is in...
|
|
1 |
118 |
|
|
|
June 25th, 2009 04:26 PM
by RagDyeR
|
2 |
131 |
|
|
Check for CAPS by
Heidi
I have a list of names in this format:
Johnson,Dave
Smith,Karen
MENDOZA,JUAN
I need to run a check and identify all the cells where the name is in all
CAPS....
|
June 25th, 2009 04:21 PM
by Heidi
|
3 |
90 |