|
|
Excel 2007 - Personal Macros by
Susan
My personal macros workbook no longer opens when I start Excel. I have found
it in the XLSTART, and I can't see anything wrong with it, but it doesn't
open...
|
|
1 |
129 |
|
|
don't know what function to use by
excelrookie
If I have in column Z1-Z10 ten company names, then in columns AA-AJ those
same company names with the area's they cover in the respective rows. Is
there...
|
|
2 |
116 |
|
|
Complex If by
PAL
Any ideas where I went wrong here. Can't leave the cell
=IF(AND(U2="YES",OR(E2="Not-applicable",E2="Red"),"Yes",""))
|
|
6 |
136 |
|
|
Weeknum formula by
exalan
Hi,
When I use the weeknum formula to calculate the week number on today's date
(5th April 2010), the result is 15 (week no.15) irrespective of the return...
|
April 5th, 2010 05:53 PM
by exalan
|
2 |
178 |
|
|
Using multiple IF statements by
KMBOhio
I am trying to create a formula using multiple IF statements. Individually
they all work but I don't know how to connect them in into one formula. ...
|
|
1 |
101 |
|
|
Time difference calculation by
Sandy
Hi
Excel 2003
In C5 i have a start time eg 12.30pm and in D5 I have a finish time eg
20.45pm.
I need to calculate the hours and minutes worked in E5, with...
|
April 5th, 2010 03:33 PM
by Sandy
|
2 |
155 |
|
|
Coloring by
Elton Law[_2_]
Dear Expert,
My office is still using Excel 2000.
Conditional format can go up to 3 only.
Is it possible to use if function to add more?
Say certain certeria...
|
|
2 |
170 |
|
|
Address of cell in VBA by
G.P.N.L. c.v.a.
I want to make a UDF,
in which I use the address of the cell itself in VLOOKUP.
How do I define the address of the cell ?
cell("address") give an...
( 1 2)
|
|
11 |
190 |
|
|
Formula Assistance - Vlookup by
Bigfoot17
I could use some guidance on this formula:
{=SUM(IF((B$8:B$55="X")*(OR(J$8:J$55=2,J$8:J$55=9))*(IF(VLOOKUP(E$8:E$55,Codes!$M$2:$N$31,2,0)=1,1,0)),1,0))}
I am...
|
|
4 |
118 |
|
|
Cell selection - turn it off by
Kris
I am having an issue where when I open an worksheet, it is automatically
selecting cells and I can't figure out how to turn this off.
As soon as I open the...
|
April 5th, 2010 01:54 PM
by Eduardo
|
1 |
119 |
|
|
|
April 5th, 2010 01:24 PM
by JLatham
|
2 |
106 |
|
|
|
April 5th, 2010 12:40 PM
by Stefi
|
1 |
100 |
|
|
Automate calculation... by
XKruodo
Hi,
Column A contains dates starting from A2:A500. H2 is where when i enter a
date , get some results in H3. I then manually type those results in column B...
|
|
1 |
114 |
|
|
|
April 5th, 2010 08:38 AM
by Bernd P
|
6 |
154 |
|
|
Countifs for multiple worksheets by
JodySmithPharmD
Can the countifs function be used to count cells across multiple worksheets?
I keep getting a #VALUE! error. I have tried changing the format of the
cells...
|
|
4 |
123 |
|
|
Text to Number format by
Janet
I have copied a column of numbers to excel and now cannot apply any formulas
because the numbers are text. How can I convert the text to numbers?
Thanks.
--...
|
|
5 |
109 |
|
|
eliminate duplicates on a sheet by
C. Brown
I have a list of 3500 names & addresses in an Excel workbook on one sheet and
some are duplicates. How do I eliminate duplicates?
|
|
3 |
172 |
|
|
SUMIF returns no value by
EricB
My SUMIF argument returns no value but when checking fx the Sum_range
reflects the correct value, but Formula result is R –
=SUMIF($A4,'TB...
|
|
2 |
126 |
|
|
Simple Consolidation of Worksheets by
nonapp2
I scanned a huge database into Excel.
It has around 300 seperate sheets.
All I need to do is combine all the sheets into one sheet.
Copy & paste would take...
|
|
2 |
110 |
|
|
|
|
5 |
116 |