|
|
Insert Menu Greyed Out by
SC-LS
I received a shared worksheet where certain features were unavailable
(inserting being one of those). After saving and closing that spreadsheet
and opening...
|
June 2nd, 2010 10:17 PM
by SC-LS
|
0 |
1,003 |
|
|
Alternative formula to HLookup by
Bernie Deitrick
BeSmart,
(I actually knew someone named B. Smart ;-0)
Simply make the row lookup parameter dynamic: in this case, replace the
4
with
ROW()-Row($BN$10)
This...
|
|
0 |
1,001 |
|
|
|
|
17 |
1,000 |
|
|
MAKE EASY MOENY by
Rajkovaca Ante
- MAKE EZ AND FAST CASH, NO JOKE, JUS READ!!!!! : MAKE
MONEY FAST!!!!!! IT WORKS!!!!!!! : IT'S SIMPLE AND IT'S
LEGAL!!!!!!! I found this on : a bulletin board...
|
|
0 |
996 |
|
|
|
|
4 |
994 |
|
|
VLOOKUP returns unwanted/wrong values by
wcollatz
I'm using the VLOOKUP function to return data from a named range which
contains several data points (across the row) for several "sites" which are
numbered...
|
September 23rd, 2008 09:57 PM
by T. Valko
|
4 |
993 |
|
|
Sort data into order of product by
Jackmac
Hi there,
I've got a list of products for my company but it is listed in product
group, the products for that group coming underneath.. like...
|
February 21st, 2006 03:08 PM
by Jackmac
|
2 |
991 |
|
|
|
|
3 |
990 |
|
|
VLOOKUP problem by
Crystal
I'm using the VLOOKUP worksheet function and I'm having
some issues with the result affecting my other formulas.
Instead of the lookup returning "#N/A" when it...
|
September 15th, 2003 04:03 PM
by Anon
|
1 |
985 |
|
|
Numbering rows for sorting by
Dan
If i understand you correctly try this:
Say you want your numbers from A1 to A1000
In A1 input the number 1.
In A2 input the number 2.
Hilight (select just...
|
September 15th, 2003 02:08 PM
by Andy B
|
1 |
983 |
|
|
Odd Drop Down Box Behavior by
Squeaky
I have a drop down box on a spreadsheet in a workbook with several
spreadsheets. For some reason the contents of the drop down box is beeing
bled through to...
|
|
4 |
983 |
|
|
|
February 26th, 2004 01:05 PM
by oldguy
|
0 |
982 |
|
|
|
|
3 |
982 |
|
|
|
|
1 |
982 |
|
|
|
|
2 |
980 |
|
|
|
|
1 |
979 |
|
|
Open.text macro fn syntax by
cuckoonuck
I have a FoxPro application which uses DDE to open a text file in Excel
and save it as a spreadsheet. I can open the text file with the
OPEN.TXT macro...
|
|
1 |
979 |
|
|
Counting cells with conditional formatting by
AOdoc
I am trying to count the cells in a range that have a certain fill color in
Excel 2003. Is there a way to use COUNTIF? If so, how do I write the criteria
for...
|
|
2 |
977 |
|
|
|
|
13 |
977 |
|
|
|
|
1 |
975 |