Thanks Asa,
You rock man.
Regards
Shekhar Sharma
On Thu, May 10, 2012 at 3:13 AM, Asa Rossoff a...@lovetour.info wrote:
Hi Shekhar,
Well, the prupose of the formula is, in the end, to lookup a text value
based on an input value. This is best accomplished with a lookup function.
Yes i need user form in sheet1 and database should be storage in sheet2, as
it is there in the cbre payplus sheet(i.e row wise).
If it is possible help me on this.
Regards
Lokesh.M
On Thu, May 10, 2012 at 1:49 AM, Asa Rossoff a...@lovetour.info wrote:
Hello Bé Trần,
I believe that is
Hi Noorain,
Thanks a lot for helping me on this running text query. Once again thanks a
lot.
But when i am opened the running text excel file it gets hang, i can't
table to edit the other cells.
So please remove the hang option in the file and provide me editing option
in cells.
Regrards
Dear Group,
Please help me, please provide the formula for the attach file, If any
employee moved from one department to any other dept. I have to make a
separate entry in the sheet, but for the payroll prospective I have to
consolidate the complete attendance in a single row. please make some
Hi,
Try this formula in F16.
=IFERROR(INDEX(F$5:F$8,MATCH(1,($A$5:$A$8=$A16)*(F$5:F$8),0)),)
Apply with Ctrl+Shift+Enter
Regards,
MARIES.
On Thu, May 10, 2012 at 11:14 AM, Surendra Singh
surendra.si...@in.aegisglobal.com wrote:
**
Dear Group,
Please help me, please provide the formula
Hello Surendra ,
PFA!
On Thursday, May 10, 2012 11:14:26 AM UTC+3, Surendra Singh wrote:
Dear Group,
Please help me, please provide the formula for the attach file, If any
employee moved from one department to any other dept. I have to make a
separate entry in the sheet, but for
Dear Rajan,Ashish,Asa,SAM,Krishna,Maries and Don Sir,
Group is waiting for your valuable contribution.
--
Thanks regards,
Noorain Ansari
www.noorainansari.com
www.excelmacroworld.blogspot.com
On Thu, May 10, 2012 at 4:49 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote:
Dear Group,
Please
Try it,
*=INT(A1)+1
*
On Thu, May 10, 2012 at 2:38 PM, Ashish Bhalara
ashishbhalar...@gmail.comwrote:
Dear expert,
The function Round(value,0) display result i.e. 125.55 to 126 and 125.45
to 125.
My result: If the value 125.55 or 125.45 or 125.01 or 125.99 then output
is 126
In short if
=ROUND(E12,0)
Regards,
Deepak Rawat
On Thu, May 10, 2012 at 5:08 PM, Ashish Bhalara
ashishbhalar...@gmail.comwrote:
Dear expert,
The function Round(value,0) display result i.e. 125.55 to 126 and 125.45
to 125.
My result: If the value 125.55 or 125.45 or 125.01 or 125.99 then output
is
*=ROUNDUP(A1,0.1)
*
On Thu, May 10, 2012 at 2:55 PM, Deepak Rawat deepakexce...@gmail.comwrote:
=ROUND(E12,0)
Regards,
Deepak Rawat
On Thu, May 10, 2012 at 5:08 PM, Ashish Bhalara ashishbhalar...@gmail.com
wrote:
Dear expert,
The function Round(value,0) display result i.e. 125.55 to
copy to I3 and enter using CSEcopy down.
=INDEX(Sheet1!$C$2:$C$140,MATCH(MIN(ABS(Sheet1!$C$2:$C$140-H3)),ABS(Sheet1!$C$2:$C$140-H3),0))
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
From: Sara Lee
Sent: Wednesday, May 09, 2012 10:01 PM
To:
=ROUNDDOWN(A1,0)
On Thu, May 10, 2012 at 5:26 PM, Maries talk2mar...@gmail.com wrote:
*=ROUNDUP(A1,0.1)
*
On Thu, May 10, 2012 at 2:55 PM, Deepak Rawat deepakexce...@gmail.comwrote:
=ROUND(E12,0)
Regards,
Deepak Rawat
On Thu, May 10, 2012 at 5:08 PM, Ashish Bhalara
OR, use this withOUT the helper column. Again CSE
=INDEX(Sheet1!$C$2:$C$140,MATCH(MIN(ABS(Sheet1!$C$2:$C$140-LEFT(C3,3))),ABS(Sheet1!$C$2:$C$140-LEFT(C3,3)),0))
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
From: Sara Lee
Sent: Wednesday, May 09, 2012 10:01 PM
To:
Dear Noorain,
really very helpful for all of us.
thanks a ton :)
Rgds,
cs
On Thu, May 10, 2012 at 4:49 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote:
Dear Group,
Please find attached Interview questions and answers for MS Excel+VBA+MS
Access+SQL Server.
If any one have this type of
Won’t a simple vlookup using the false parameter work..??
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
From: Smitha S R
Sent: Wednesday, May 09, 2012 8:43 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Office stock
Hi
PFA the stock statement where I
Hi Asa Rossoff
I'm working on a solution, with the help of friends, when finished. I
send a result
Chilexcel
2012/5/8 Asa Rossoff a...@lovetour.info:
Hi Chil,
Did you try to use those functions, and if so, please post your effort and
what trouble you are having.
Asa
-Original
Excellent. I hope I didn't give the impression I was unwilling to help
more. I am happy to. But if you need more help, I prefer a specific
question than just giving a complete solution... so you can gain the most
experience and expertise.
Asa
-Original Message-
From:
I understand, I prefer a complete solution , not partial, my job is
to solve specific problems.
excel is my work tool..applications, tools, add ins , all in excel
I know much about excel, but, not I know all
however, advise use excel , for solutions informaticas , is a good tool
Maybe
Hi Chilexcel,
The problem for me comes because if the person requesting help does not look
at themselves as a student in the relationship, then it seems to me they are
just asking me to do their job for them... but I am not getting paid. I
know you are very skilled already...
Yes, Microsoft
I understand
Thank you for your attention and for your time, I have nothing more to add
thanks again
Chilexcel
2012/5/10 Asa Rossoff a...@lovetour.info:
Hi Chilexcel,
The problem for me comes because if the person requesting help does not look
at themselves as a student in the
Thanks all
I get it exactly what i want.
Ashish
On Thu, May 10, 2012 at 6:09 PM, Waseem Saifi waseemsa...@gmail.com wrote:
=ROUNDDOWN(A1,0)
On Thu, May 10, 2012 at 5:26 PM, Maries talk2mar...@gmail.com wrote:
*=ROUNDUP(A1,0.1)
*
On Thu, May 10, 2012 at 2:55 PM, Deepak Rawat
21 matches
Mail list logo