|
|
Formula to identify text into columns by
Forgone
I've been given a question in excel and I think it can be done but
can't figure out how to do so.
The worksheet they have has in Column A - a description of a...
|
|
7 |
79 |
|
|
MOREFUNC by
lehigh46
Hi All:
For some reason Morfunc is not working.
I tried re-installing it, but after that Excel does not recognize it
anywhere.
I spcificly need it for...
|
|
1 |
59 |
|
|
Link updates Excel 2007 by
Alain Schneiter
Hi,
We have svereal spreadsheets with exeternal contents. Excel 07 always starts
with trying to update this links even if we change the settings in the trust...
|
|
6 |
77 |
|
|
vlookup 2 arguments by
lab-guy
I've seen several responses about using match and index to accomplish;
don't see it working for me.
Need to do:
Select Grade from Datablock
where student_id...
|
|
4 |
70 |
|
|
Comparing Excel Dates by
Dashman
I have a list in which I want to find similar dates and times in a column and
extract the earliest date/time. I have been manually sorting the date/time...
|
March 17th, 2009 02:21 AM
by Dashman
|
5 |
60 |
|
|
|
|
1 |
71 |
|
|
|
|
1 |
83 |
|
|
Lookup closest to by
sgl
I have the following table
Name Date Amount
Anemi Test 31-Dec-11 ...
|
|
5 |
77 |
|
|
Whats wrong with this function? by
Angelsnecropolis
B45 =IF(AVERAGE(B34:D340), AVERAGE(B34:D34),"")
It works fine when there is a number in B34 but if B34 is blank, even though
C34 and D34 are not blank, B45...
|
|
5 |
44 |
|
|
|
|
0 |
492 |
|
|
Attach code by
MAX
How to attach the code to a Sheet_Change event
|
March 17th, 2009 12:11 AM
by MAX
|
5 |
342 |
|
|
Conditional Formatting by
Joe Gieder
First thank you for your help.
I'm trying to use conditional formatting to highlight the cell that is the
lowest among these cells and I tried using this...
|
|
2 |
75 |
|
|
Outline/group data below by
Steve[_7_]
In xl2007, to the bottom right hand side of the "Outline" section
(where the group and ungroup buttons reside), click on the small
arrow. This is the setting...
|
|
0 |
61 |
|
|
basketball bracket by
tonyalt3
Does anyone out there have a spreadsheet that would check to see if
tournament picks are correct/incorrect and then total up points on a
summary page?
|
|
5 |
78 |
|
|
|
|
4 |
58 |
|
|
Even or Odd Year Function by
Dave H[_12_]
I am trying to use the Year Function =Year(A1). If A1 is actually a
vlookup when I place the fubction in cell B1 it works fine. However if
I place...
|
|
3 |
91 |
|
|
call external function by
DavidB
How do I convert a column of IP addresses to resolved DNS names (eg using the
Windows command line function nslookup() - I wonder why this isn't a standard...
|
March 16th, 2009 10:04 PM
by DavidB
|
2 |
78 |
|
|
|
|
3 |
59 |
|
|
Vlookup to find a match in a string by
KCK
Hello, I am trying to use vlookup to match the contents of a cell with a
portion of a text string and return another cells data. Maybe using Index and
Match...
|
March 16th, 2009 08:59 PM
by KCK
|
6 |
55 |
|
|
|
|
5 |
49 |