|
|
|
|
4 |
282 |
|
|
|
|
2 |
268 |
|
|
Add and edit a shape in VBA by
Hugo Jorgensen
Hi, I have written code to add a rectangle and a line in VBA. When I run the
code it sometimes works fine. If I use F8 to step through the code the code
to...
|
|
1 |
285 |
|
|
|
|
0 |
230 |
|
|
Excel formula by
james
Hi all, looking for help with a formula,
I have column G which is money recieved, ideally this should be €40 in each
cell, however sometimes it is more or...
|
April 19th, 2010 03:46 PM
by Eduardo
|
1 |
201 |
|
|
|
April 19th, 2010 03:41 PM
by RebLan
|
4 |
279 |
|
|
|
April 19th, 2010 03:14 PM
by Me
|
4 |
263 |
|
|
Script to insert Row by
Jeremy
How would I write a scrtip to insert a row under the number in A that holds a
"NS" or "MT"? I would also like it to copy the row that has "NS" or "MT" in
it...
|
April 19th, 2010 02:39 PM
by Mike H
|
2 |
211 |
|
|
Excel custom format q by
domyrat
There is one problem that needs help from experts.
I got data:
Cell A1: AA-BB-999-xxxxx-zz-Abcdefghij Klmno 9, PRSTUVW
Cell A2: AA-BB-888-zzzzz-zz-Abcdef...
|
April 19th, 2010 01:11 PM
by domyrat
|
3 |
215 |
|
|
How to undo overwrites? by
undo overwrites
i was typing my data whereby i accidentally overwrite the new file on the
existing file name...is there any way to undo that?
|
April 19th, 2010 12:59 PM
by Eduardo
|
2 |
201 |
|
|
IFBLANK by
mrtintheweb
I have a spreadsheet that has dates in. The spreadsheet needs pre-poulated
boxes that are blank but will show dates once data has been input.
eg:
A B ...
|
|
2 |
180 |
|
|
Conditioinal Formating Question by
Harminder
Hi I'm trying to do a conditional format where as if two values from two
different cells equal a number a letter is displayed as apposed to a colour?
Thanks...
|
|
2 |
218 |
|
|
Excel, custom format by
domyrat
I have data entered like this :
AA-BB-999-xxxxx-zz-Abcdefghij Klmno, PRSTUVW
AA-BB-888-zzzzz-zz-Abcdef Ghijk, LMNOPRSTUV
When i enter the data in A1, A2...
|
|
5 |
190 |
|
|
How to arrange data by
Amin
Hi i am about eating an inventory database for a small makeup store, however
thier product are many in terms of category and group. you have the lip
glosses...
|
April 19th, 2010 09:48 AM
by Amin
|
3 |
227 |
|
|
Advanced Formula troubles by
Eves
I need to do the following calculation:
((1-((1-AE5)*10))*V14)
but only when:
((1-((1-AE5)*10))*V14)=0 or =V14*1.5
If greater than or = to V14*1.5 then...
|
|
3 |
188 |
|
|
|
|
1 |
218 |
|
|
|
|
1 |
187 |
|
|
Rating by
Kareem
please Sir:
if i take salary as 1000 $ per month , and this amout increasing annually by
10% it comes 1100$ then 10 % for next year and so on....
how can i...
|
|
3 |
196 |
|
|
Countif Formula by
Khalid A. Al-Otaibi
A B
1 112233 Expired
2 113344 Valid
3 116655 Valid
4 117799 N/A
This Formula is to calculate the number of employee in the column.
=COUNTIF(A1:A4,"*").
|
|
1 |
196 |
|
|
segreating duplicate Trasactions 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 ...
|
|
4 |
178 |