|
|
|
|
0 |
259 |
|
|
Return date of an action by
Jacob Skaria
If you have excel dates in the 1st row; dont forget to format the formula
cells to date format
--
Jacob (MVP - Excel)
"Jacob Skaria" wrote:
Hi Ben
|
|
0 |
218 |
|
|
ISNA and ISERROR functions by
Jacob Skaria
Try these formulas
'If the lookupvalues is not found it will return a na() error
=VLOOKUP("something",Sheet2!A:B,2,0)
'returns true if value is not found and...
|
|
0 |
207 |
|
|
What is an "add-in"? by
PBG
What is an "add-in"? How does it work and how to make one?
Thanks
(the newbie is back)
|
May 27th, 2010 10:13 PM
by PBG
|
0 |
171 |
|
|
Help writing a formula by
WA
I AM SO CLOSE! :-)
Both ck13 & Ms-Exl-Learner have helped me down the path but I have 1 piece
missing.
Heres what I have now (Col A - done, Col B - not...
|
May 27th, 2010 10:11 PM
by WA
|
0 |
180 |
|
|
|
May 27th, 2010 10:11 PM
by GORSO
|
5 |
1,034 |
|
|
Find and Replace by
vicktina
We are using a scanner to input a barcode number into "Find What" box in find
and replace in excel. Is there a way to make it stay highlighted for the next...
|
|
0 |
170 |
|
|
|
|
1 |
269 |
|
|
Conditional Formatting & Macro by
MickyRat
Is it possible to write a Macro to make changes 2 another Macro. I have a
complicated macro which may have 100 formulas, each day I add data which then...
|
|
0 |
258 |
|
|
Deleting Rows on the basis of cell comment by
Radhakant Panigrahi
Hi,
i need to delete the rows where the comment in the column A contains some
charaters...for example below are the comment in column A...and i need to...
|
|
4 |
256 |
|
|
Format Pivot Table by
EricG[_2_]
Right-click anywhere in the pivot table and select "Pivot Table Options...".
Make sure the box that says something like "Preserve Cell Formatting on
Change"...
|
|
0 |
246 |
|
|
Excel 2010 - Save as XML by
AndyW
Hi folks,
I have a simple workbook that was created from importing a CSV file. It
just contains 4 columns of data.
I would like to export the data as XML...
|
May 27th, 2010 10:02 PM
by AndyW
|
0 |
234 |
|
|
Help writing a formula by
ck13
Hi, I dun really understand what is your end product but just give it a try
and maybe you can make something out of it. I assume that you have
information in...
|
May 27th, 2010 10:00 PM
by WA
|
1 |
182 |
|
|
|
May 27th, 2010 09:59 PM
by racee
|
12 |
396 |
|
|
Sumproduct using multiple sheets by
Jacob Skaria
--One approach is to use your formula in each sheet say in cell C1 and then
in your summary sheet use a formula which will return the totol from all...
|
|
0 |
199 |
|
|
|
|
1 |
312 |
|
|
|
|
0 |
248 |
|
|
Programmable Column Sequencing? by
G
I am currently using Excel 2003 and 2007 if necessary.
I would like the ability to configure the excel sheet column sequencing when
I hit the enter key or...
|
|
2 |
267 |
|
|
What is an "add-in"? by
FSt1
hi
a add in is a special xl file usually with a .xla file extention that will
load in the background when xl starts. it usually contains extra code or...
|
May 27th, 2010 09:54 PM
by FSt1
|
0 |
159 |
|
|
Extract numbers from a string of text by
Huber57
Marcella,
Use the 'text to columns' function under in the data ribbon (2007) or the
Data drop-down menu (2003). Use the 'fixed-width' selection and position...
|
|
0 |
250 |