|
|
Needed Macro and Function Help by
GEdwards
Using Excel 2003 I have 2 Workbooks.
MY GOAL...
WB1, worksheet "Input Data" needs to search for an entry in column B of WB2,
worksheet "Data Sheet". If the...
|
|
1 |
178 |
|
|
Protecting an excell workbook by
cufc1210
I have a workbook which has 15 worksheets in it. It is on a network drive so
other people can access it.
I want to allow people to view the workbook without...
|
|
2 |
259 |
|
|
defaulting to Euros by
dstiefe
Somehow my excel file defaults to formatting numbers in Euros
how do i change that in 2007?
when i first started everything was just entered as a regular...
|
April 21st, 2010 05:01 PM
by dlw
|
3 |
267 |
|
|
|
April 21st, 2010 04:57 PM
by JLatham
|
3 |
229 |
|
|
|
April 21st, 2010 04:51 PM
by JLatham
|
1 |
261 |
|
|
Default font/Size in Comments Box by
Paul Calcagno
I'm running MS Office 2007 on a Vista Home Premium OS SP2, all WU's current,
with 2 GB of RAM. Windows defender, Spyware Doctor, MBAM, SAS. Everything's...
|
|
3 |
384 |
|
|
Conditional Format by
andiam24
Hello,
I would like to set a conditional format to color each unique value a
different color. It will also be applied to multiple occurences of the value....
|
|
2 |
194 |
|
|
|
|
1 |
220 |
|
|
Subtotals in Excel by
Julie
Hi Everyone, im stuck.... im doing my NVQ Level 3 in IT and one of the things
i have forgotten is the subtotals function i've set it all up correct but it
is...
|
April 21st, 2010 03:21 PM
by Julie
|
0 |
196 |
|
|
Arrow Keys by
Terry
my arrow keys (up down right left) decieded not work only in Excel. What did
I turn off?
|
|
1 |
231 |
|
|
bahttext by
javed
THE BAHTTEXT FUNCTION RETURNS THE VALUE OF A NO. IN BAHT TEXT. IN THE HELP OF
THAT PARTICULAR FUNCTION, IT SAYS THAT THIS FOIRMAT CAN BE CHANGED TO OTHER...
|
|
1 |
178 |
|
|
|
|
1 |
171 |
|
|
lookup row number by
Michael
Hi,
can you tell me how to lookup the row number of a name in a list.
EG say I have a list of names as below:
Andrew
Mike
Steve
Ian
Paul
|
April 21st, 2010 02:42 PM
by Michael
|
3 |
231 |
|
|
Concatenate lists by
Hanspeter
Is there an Easier way to Concatenate a number of cells greater than 50 cells
in once cell without using A1&"_"&A2&"_"& and so on.
HAns
|
|
3 |
226 |
|
|
Segregating Duplicate Transactions by
Radhakant Panigrahi
Hi,
can anybody help in the below query
i have the below data with me
RECEIPT_NUMBER TRX_NUMBER PAYMENT_AMOUNT Comments
9907893007 7000604737 151.06 ...
|
|
3 |
178 |
|
|
Lookup formula by
Michael
Hi,
I have a lookup formula like this:
=IF(ISERROR(IF($D1="ruth baybutt",HLOOKUP(A$3,ruth
baybut!F:N,3,0),HLOOKUP(A$3,sheet1!F:N,3,0))),0,IF($D1="ruth...
|
April 21st, 2010 02:14 PM
by Michael
|
1 |
255 |
|
|
|
April 21st, 2010 02:04 PM
by Bob I
|
1 |
211 |
|
|
How do I add extra data to a pivot table? by
Max
I know this might sound slightly simplistic, but my pivot table pulls data
from a separate tab. I know if I go in and amend the data in that table and
then...
|
|
3 |
317 |
|
|
charts with percentages by
Mar
I have made a chart in word with percentages in a data label, when I change
my figures in my excel worksheet it changes the pie chart shape, but not the...
|
April 21st, 2010 01:33 PM
by Mar
|
0 |
205 |
|
|
|
|
5 |
240 |