|
|
|
|
1 |
334 |
|
|
stop changing of format by
DCZH
I want Excel to stop changing my set word wrap funtionality from off to on
when copying or deleting data in a workbook. I will copy data from one sheet
to...
|
May 28th, 2010 03:01 PM
by DCZH
|
0 |
354 |
|
|
lookup with IF criteria by
cv8497
I am needing to look up data from a seperate report in which the VLOOKUP
formula will not work as there are multiple instances of the lookup value in
such. ...
|
May 28th, 2010 02:39 PM
by cv8497
|
2 |
321 |
|
|
INDIRECT by
Andrew Mackenzie
I would be grateful for any halp with this.
I am trying to reference a cell in a different workbook using the INDIRECT
function but I am returning #REF. This...
|
|
3 |
358 |
|
|
Backup Excel file by
Hema
I want to take backup of a file every time. I am using - save as - tools -
general option - always create back up. The backup file is in the same
location...
|
|
1 |
328 |
|
|
Make iteration default for a specific file by
bnmohan via OfficeKB.com
Hi!
I have an excel file that needs iteration. However, it appears the setting
saved with the file is sort of global: If it is opened with a fresh instance
of...
|
|
1 |
398 |
|
|
|
|
1 |
381 |
|
|
|
|
1 |
335 |
|
|
Sumproduct with multiple date criteria by
StonyfieldRob
Having a tough time with this one.
Sheet 1
Column A = Start Date, Column B = End Date, Column C = Quantity.
Sheet 2
Row A = Start Date, Row B = End Date.
I...
|
|
1 |
381 |
|
|
|
May 28th, 2010 10:53 AM
by wynand
|
1 |
341 |
|
|
Combine 2 worksheet change events by
nobbyknownowt[_10_]
I have a worksheet that I want to place 2 worksheet change events on. i
know that I cannot do this and that I have to combine them into one. I
just cannot get...
|
|
0 |
337 |
|
|
|
|
2 |
391 |
|
|
|
May 28th, 2010 07:55 AM
by BillD
|
4 |
357 |
|
|
|
|
28 |
1,365 |
|
|
Center All Pictures in Excel Cells by
Finny[_3_]
Please help. Right now I have a UDF that I found online that lets me
insert a picture into a cell by referencing the exact location on my
hard drive where the...
|
|
1 |
690 |
|
|
Help writing a formula by
WA
I have a huge database that I need to create numbering for each line like
this example: AK-233 (2 letter state, a dash, and 1-4 digit number), but the
number...
|
|
3 |
335 |
|
|
|
|
1 |
348 |
|
|
Date Formatting by
Tommy
I receive data everyday with the dates in the following format - 1/12/2025
(dd/mm/year), however I'm trying to format it to the following format-...
|
|
1 |
361 |
|
|
sum of timesheet by
nidabland
Let's say A1: 9 am
A2: 12 pm
A3: 12:30 pm
A4: 3 pm
I need the total in A5 to calculate how many hours worked, but also...
|
|
2 |
280 |
|
|
|
|
1 |
341 |