Dear Shiv Pratap
There is no built in function in excel to do it. You have to use custom made
function for the same which are quite difficult to come by (even ASAP
utilities does not provide for one!).
CA_logo_icai Small1
Anil Kumar Agarwala
Anil Agarwala & Co.
Chartered Accountants
Maybe u need a combination of Data Validation and VLookup Function. Please
attach a sheet with data so that solutions can be provided.
CA_logo_icai Small1
Anil Kumar Agarwala
Anil Agarwala & Co.
Chartered Accountants
3rd Floor, Adiba Mansion
Maszid Lane, Kamarpatty
Fancy Bazar
Guwa
Dear Hemant,
You can protect your VB project with a good password and that would be the best
solution to your predicament! No one can then view your code, leave alone
modify them.
Sorry that I am unable to comment on the registry thing.
Anil Kumar Agarwala
Anil Agarwala & Co.
Chart
Hi Ruchi,
Why don't you try with 1 in the vlookup instead of 0 thus
=VLOOKUP(B2,F3:G99,2,1)
I believe you will get the desired result.
CA_logo_icai Small1
Anil Kumar Agarwala
Anil Agarwala & Co.
Chartered Accountants
3rd Floor, Adiba Mansion
Maszid Lane, Kamarpatty
Fa
Hi Michael
You may use =MIN(500,
IF(A11<=6000,IF(A11<0,#VALUE!,ROUND(A11*0.012,2)),72+ROUND((A11-6000)
*0.009+18,2)))
This will give you the minimum of either values.
Anil Kumar Agarwala
Anil Agarwala & Co.
Chartered Accountants
3rd Floor, Adiba Mansion
Maszid Lane, Kamarpatty
F
Hello JM
The custom addins can be added in Excel 2007 through the Office Button. \
Click on .
Anil Kumar Agarwala
Anil Agarwala & Co.
Chartered Accountants
3rd Floor, Adiba Mansion
Maszid Lane, Kamarpatty
Fancy Bazar
Guwahati : 781001
Assam
+91 361 2638864 (Telefax)
+91 361 2517820 (Office)
Hello JM
The custom addins can be added in Excel 2007 through the Office Button. \
Click on .
Anil Kumar Agarwala
Anil Agarwala & Co.
Chartered Accountants
3rd Floor, Adiba Mansion
Maszid Lane, Kamarpatty
Fancy Bazar
Guwahati : 781001
Assam
+91 361 2638864 (Telefax)
+91 361 2517820 (Office)
Instead of using the nested IF function which makes the formula quite
complicated, you can just use the weekday and custom format your cell as
and get the desired result. Or as Dev suggested, Text(A1, "") works
just as fine.
Anil
From: excel-macros@googlegroups.com [mailto:[EMAIL P
Hi all,
It should be "Weekday", not "Day" function as Maddy as suggested, I suppose.
The day function returns the day of the month, not of the week.
Regards
Anil
From: excel-macros@googlegroups.com [mailto:[EMAIL PROTECTED]
On Behalf Of muralidhar rao
Sent: Tuesday, October 14, 2008 6:07
Use the formula in cloumn 3
=IF(A5<>A6,B5,""). Fill it in each row.
Then filter column 3 for non-blanks.
NB: It will be best if you format the data as a table (or excel list).
CA_logo_icai Small1
Anil Kumar Agarwala
From: excel-macros@googlegroups.com [
F4 is working just as fine in Excel 2007 as it was in earlier versions.
Kindly recheck. If you changed your laptop/PC see if the function key works
with Fn key pressed.
Anil Kumar Agarwala
Anil Agarwala & Co.
Chartered Accountants
3rd Floor, Adiba Mansion
Maszid Lane, Kamarpatty
Fancy B
Dear,
Use the following formatting options with either concatenate or "&"
=concatenate(TEXT(A1,"DD/MM/ h:mm:ss AM/PM"), " ",B1)
Or
=TEXT(A1,"DD/MM/ h:mm:ss AM/PM")& " "&B1
CA_logo_icai Small1
Anil Kumar A
;15"
is to be displayed as "15", you could custom format the cell/cells using
the format cell dialogue box and typing 00 using custom format.
Anil Kumar Agarwala
Guwahati : 781001
Assam
akagarw...@gmail.com
-Original Message-
From: excel-macros@googlegro
13 matches
Mail list logo
