|
|
Mandatory/Compulsory by
Md.Siddique[_2_]
Hi Sir,
I need to put a formula for a cell as mandatory/compulsory it has to fill,
otherwise it will not go to the next cell. It has to display (customized)...
|
|
2 |
178 |
|
|
Sharing a workbook in excel 2007 by
Susan
I have a workbook that i have created in excel 2007 with macros. I need to
allow sharing now. I understand macros can not be viewed or edited which is...
|
April 21st, 2010 01:09 PM
by Susan
|
0 |
245 |
|
|
|
|
2 |
210 |
|
|
Conditional formatting of date-cell - 2007 by
UlfHJensen
I would like to conditional format cells - in colors - containing a date if
date in cell is before or after TODAY(). This is not - strangely - an option
in...
|
|
5 |
215 |
|
|
|
|
5 |
241 |
|
|
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 |
208 |
|
|
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 |
319 |
|
|
|
April 21st, 2010 02:04 PM
by Bob I
|
1 |
217 |
|
|
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 |
261 |
|
|
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 |
179 |
|
|
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 |
227 |
|
|
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 |
232 |
|
|
|
|
1 |
178 |
|
|
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 |
179 |
|
|
Arrow Keys by
Terry
my arrow keys (up down right left) decieded not work only in Excel. What did
I turn off?
|
|
1 |
237 |
|
|
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 |
202 |
|
|
|
|
1 |
226 |
|
|
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 |
195 |
|
|
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 |
386 |
|
|
|
April 21st, 2010 04:51 PM
by JLatham
|
1 |
269 |