|
|
Search / Find Function by
Harry C.
I would like Excel to count all my NY customers; e.g., Search("NY",B2) if
the state code NY is found in a lengthy text field containing a name,
address,...
|
|
6 |
143 |
|
|
|
June 16th, 2009 05:20 PM
by dave
|
0 |
149 |
|
|
COMMON NUMBERS by
sood
I have lists of various telephone numbers in multiple coulmns containing
different rows and there may be same numbers existing in these coulmns and
rows. I...
|
June 16th, 2009 04:02 PM
by sood
|
2 |
149 |
|
|
EXCEL by
Yolande van der Westhuizen
I need a bit of help. Ive got a excel sheet, with lots of data for
200 patients (1 Patient per row). One test that was performed on
these patients had the...
|
|
2 |
122 |
|
|
Linking Objects by
Humble09
Hi,
I would like to know is it possible to link a cells to one column. I have a
person who has mutliple keys and I would like to list all those keys in one...
|
|
0 |
144 |
|
|
|
|
4 |
116 |
|
|
Spell Check by
Warm
Hi,
can someone please explain why this proction macro does not allow the spell
check function to work when the 'userinterfaceonly' option is in it?!
Sub...
|
|
3 |
150 |
|
|
|
June 16th, 2009 02:36 PM
by Luke M
|
1 |
119 |
|
|
Autofilter query? by
Me!
A colleague has a problem whereby when he colours selected rows when the
Autofilter is on, and then removes the filter, not only his selected rows
are...
|
|
1 |
170 |
|
|
|
|
2 |
153 |
|
|
|
|
2 |
128 |
|
|
Message box date format macro help by
Aaron
Sub proving()
Worksheets("Proving Equipment").Visible = True
Sheets("Proving Equipment").Select
If (n62 + 31) o62 Then
MsgBox ("Proving Equipment...
|
June 16th, 2009 08:16 AM
by Aaron
|
2 |
118 |
|
|
Message box date format macro help by
Aaron
Sub proving()
Worksheets("Proving Equipment").Visible = True
Sheets("Proving Equipment").Select
If (n62 + 31) o62 Then
MsgBox ("Proving...
|
June 16th, 2009 07:17 AM
by FSt1
|
2 |
153 |
|
|
VLOOKUP: Wont return value by
mind_killer
Hi,
I have the opposite problem of some of those here. VLOOKUP is returning #N/A
when it should be returning a value.
The formula I am using is:...
|
|
6 |
188 |
|
|
|
|
1 |
126 |
|
|
surya and siva by
surya and siva[_2_]
hi i have a senario, please give me formula
A B c d
site patient querystatus querycount
209 517 answered ...
|
|
0 |
112 |
|
|
Copy A1 into C1 if B1 contains data?? by
Question, Mark
I want to copy whatever is in A1 into C1 if B1 has data. If b1 is blank then
c1 should remain blank. The data in a1 or b1 could be either text or
numbers....
|
|
3 |
155 |
|
|
|
June 16th, 2009 03:26 AM
by RagDyeR
|
14 |
309 |
|
|
Populating Data From Drop-Down Item by
MR
Is there any way to click on an item in a drop-down box and have sets of
information populate in another cell as a result of clicking on that item?
i.e.
I...
|
|
1 |
119 |
|
|
|
|
2 |
150 |