|
|
|
|
3 |
85 |
|
|
comparison function by
NEHicks
I have 2 worksheets -
Worksheet A
Name, SSN, Discharge Date, Discharge Appointment Time, Discharge Time
Worksheet B
Name, SSN, Ward, Discharge Appointment...
|
April 22nd, 2009 03:20 AM
by smartin
|
1 |
133 |
|
|
|
|
2 |
63 |
|
|
Return two random lines by
Jeremy
I need to randomly select two lines per person listed on my report. How can
I do this?
|
April 22nd, 2009 03:16 AM
by smartin
|
1 |
85 |
|
|
|
|
5 |
92 |
|
|
Self Population of Date Function by
SW[_4_]
I have formulas in a column that self populate dates in each succeeding cell.
I would like to be able to have the cells stop self populating on the 25th
of...
|
|
1 |
96 |
|
|
macro writing by
dannyboy8
Good afternoon, I have several worksheets that are pulling information from a
company drive, the worksheets are pulling information from several sources
but...
|
April 22nd, 2009 02:51 AM
by smartin
|
1 |
72 |
|
|
Medians of data by
Pendelfin
Hi
Please can anyone let me know what the formula would be to let me know the
median of a range of numbers depending on the types -...
|
|
3 |
64 |
|
|
|
|
1 |
66 |
|
|
Drop down menus by
Kirsty
Afternoon,
When using drop down menu's, is there a function that when you type in the
first few characters it finds the name, rather than scrolling through...
|
|
2 |
55 |
|
|
|
|
3 |
56 |
|
|
conditional list by
sailingHLA
I am trying to create a dependent list for a drop down menu. My table is set
up as follows:
A B
Mammal Cat
Mammal ...
|
|
1 |
56 |
|
|
extract items from filtered list by
andy62
I need to set up a report that dynamically displays on another sheet items
from one column of a filtered range. After the advanced filter is executed,
I may...
|
|
1 |
59 |
|
|
Can't sort with Excel 2007 by
caherpeak
I was able to sort large tables easily with Excel version 2003.
With Excel 2007, sorting does not function effectively.
There are entire gaps in between rows...
|
|
0 |
46 |
|
|
symbals by
menard, joseph
where is the symbal selection?
|
April 21st, 2009 09:26 PM
by FSt1
|
1 |
56 |
|
|
|
|
3 |
89 |
|
|
Close Match by
[email protected]
Hi All,
I have two sheets ( sheet1 and sheet2)
Sheet1 Col A has Client name ( unique ) - Approximately 20,000 Rows
Sheet 2 Col A has Client name and Col B...
|
|
0 |
56 |
|
|
vlookup removing characters by
ryan
I'm trying to lookup a value where my lookup_values contain extra text.
e.g.
lookup_values = "Los Angeles, CA TOTAL
the table array will have Los Angeles,...
|
April 21st, 2009 08:28 PM
by ryan
|
2 |
48 |
|
|
|
April 21st, 2009 08:23 PM
by SPISO
|
0 |
61 |
|
|
|
|
4 |
74 |