Dear Jocky,
please find attached sheet..
Formula is here...
=IFERROR(VLOOKUP($F$2,DATA!$B$2:$G$8,3,0),)
Thanks regards,
Noorain Ansari
On Sun, Jan 16, 2011 at 11:33 PM, Manoj kumar
manoj.vishwakarma...@gmail.com wrote:
Attached for ur reference
Regards,
Manoj Kumar
On
For contact person ur formula should be
=VLOOKUP($F$2,DATA!$B:$G,3,0)
And so on.
i.e instead of A it shoul start from B.as unique value is in col. B.
Hope it will haelp u.
On 17 January 2011 12:16, jocky Beta jocky6...@gmail.com wrote:
Hi,
I made a Excel sheet with help of V lookup using
Dear all
I have a problem in Excel Graph .
Please find attached Sheet and help me
Please lok at the graph ( I want to chenage the Legend and C should be on
top then D then B then A)
Can any one help me to do this
Thanks in advance
Waiting for reply
--
Shrini
--
Dear Team,
Please find attach file in which i have explained my requirement and request
of your kindness to provide me the solution, *as i have more than 4000
records of such data*.
Thanks Regards
Priya
--
--
Some
Good Formula! Please brief its logic especially about 2.
On Sun, Jan 16, 2011 at 10:27 AM, Ms-Exl-Learner . ms.exl.lear...@gmail.com
wrote:
Hi John,
It will work in version 2003 if you refer the cell reference to part of the
column range instead of referring it to the whole column.
Hi Hanumant,
I have also faced this while approving messages.
I think its a bug of Google groups and not any issue at your end.
I hope it helps.
Best Regards,
Ayush Jain
Group Manager.
On Mon, Jan 17, 2011 at 1:28 AM, hanumant shinde
hanumant_5...@yahoo.co.inwrote:
Hi Friends,
some time
Hi
Se att, u can do with pivot table.
Rgds
Enjoy excelling...
On Mon, Jan 17, 2011 at 7:04 PM, Priya Jose questpr...@gmail.com wrote:
Dear Team,
Please find attach file in which i have explained my requirement and
request of your kindness to provide me the solution, *as i have more
Hi Manoj,
Thanks for the Information, But when i individually insert range_lookup
value 0 it shows #NA value in contact person, Hence i request you to please
give me the Step by step details from starting to do the Same(from how to
make drag drop list to Last one)
Looking foreword for your
can u help me any one how to use offset, index, match in indepth
i know basics to use these functions
i need indepth summery
using arrays like that
i need more and more help for offset function
thanks in advance
--
Date Time
04/15/2009 06:02:35
04/14/2009 16:46:49
04/14/2009 16:46:49
04/14/2009 16:46:49
04/14/2009 16:46:48
04/14/2009 23:58:34
i need this kind of format in internally, formula bar have this kind
of format only i dont need am or pm in internallcell formula in
formula bar
how to change this
check the attachment se eif it helps
On Mon, Jan 17, 2011 at 7:04 PM, Priya Jose questpr...@gmail.com wrote:
Dear Team,
Please find attach file in which i have explained my requirement and
request of your kindness to provide me the solution, *as i have more than
4000 records of such
goto control panel - reginal settings - select time and click on customise
- click on time tab and choose H:mm option
On Mon, Jan 17, 2011 at 8:21 PM, renuka chari jva.ch...@gmail.com wrote:
Date Time
04/15/2009 06:02:35
04/14/2009 16:46:49
04/14/2009 16:46:49
04/14/2009 16:46:49
send us the sample workbook
On Mon, Jan 17, 2011 at 12:10 AM, Seba sebastjan.hri...@gmail.com wrote:
Hello all,
I have a question regarding building a database. I have a workbook for
each of my projects. I would like to have a macro, which would extract/
copy certain data (always in the
Dear experts,
How to resolved attached query, can anybody tell formula not macro.
Regards,
Aamir Shahzad
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
Dear Masters,
I have one issue..
I am creating one file wants to use data validation with list (giving name to a range of vendor). My data sheet contains few columns.ColumnA - Vendor name, B - service type. As one vendormay provide I have 2 or more options in column B against same vendors.
Sorry Aamir, Can't understand the question. If your worksheet had a cell with
the desired answer in it (entered manually) this may help me understand your
request.
Regards - Dave.
From: aamirshahza...@gmail.com
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Query
Date: Mon, 17
check the attachment see if it helps you
On Tue, Jan 18, 2011 at 10:36 AM, Dave Bonallack
davebonall...@hotmail.comwrote:
Sorry Aamir, Can't understand the question. If your worksheet had a cell
with the desired answer in it (entered manually) this may help me understand
your request.
Hi Ayush,
Thanks for clarification.
From: ayush jain jainayus...@gmail.com
To: excel-macros@googlegroups.com
Sent: Mon, 17 January, 2011 8:00:52 PM
Subject: Re: $$Excel-Macros$$ Empty Mail
Hi Hanumant,
I have also faced this while approving messages.
I think
Hi Srinivasan,
Thanks for the reply.
there is no sample data . i just wanna know hw can i know if the specifi value
(lets say hanumant) is present in specific range or not (lets say A1:A1000).
so i can say i wanna check IF hanumant is present in A1:A1000 range. but i
dont wanna type any
Hi group,
Awaiting for your help
On 1/16/11, maulik desai mauliksde...@gmail.com wrote:
Hi Excel Gurus,
I am having excel database I want the Diff excel workbook to be save
on basis of walkin date Process from sheet1 (Excel Database) in
D:\output Data\Sheet name walk In Date with year
Hi,
Can some provide me the solution,Awaiting for your responce.
On 1/16/11, maulik desai mauliksde...@gmail.com wrote:
Hi excel Guru's
1)I want a macro which can able to Provide the unique entry on the
basis of walk in date , Date of Birth name
2)I am having 3 excel Sheets. In Sheet1 I
Dear Amir,
Pl provide more clarity wid complete example.
a href=http://www.signaturebar.com/img src=
http://www.signaturebar.com/uploads/images/24667.png border=0/a
On Tue, Jan 18, 2011 at 12:01 AM, Aamir Shahzad aamirshahza...@gmail.comwrote:
Dear experts,
How to resolved attached
TYPE THIS IN B1 =IF(COUNTIF(A1:A1000,hanumant )=1,true,false)
On Tue, Jan 18, 2011 at 9:48 AM, hanumant shinde
hanumant_5...@yahoo.co.inwrote:
Hi Srinivasan,
Thanks for the reply.
there is no sample data . i just wanna know hw can i know if the specifi
value (lets say hanumant) is
Hi Guys need your help,
I have 25 agenst overall I have to record listen to 12 calls per agent,
While rating a call i'll put scores in sheet one automatically it should
get updated in sheet 3 i.e. summary sheet all the scores shuld get
accumulated...
Thanx in advance
Regards,
Lucky
--
Hi Jocky,
The reason you are getting #NA error because your criteria for *
table_array* * * (*This is the table of data that VLOOKUP searches to find
the information you are after.*) is wrong. Your range should start from
column B and not A because the value you want to find in the B column of
Hi Hanumant,
use it like IF($A$8 =a,1,) and drag the formula till A14 or till last
row it will give u 1 only if the cell will contain a.
Try this out.
Rgds,
Mayank
On Mon, Jan 17, 2011 at 1:03 AM, hanumant shinde
hanumant_5...@yahoo.co.inwrote:
Hi Friends,
I want to use IF condition like i
Hi Group,
I am trying to add icon sets in excel 2007.
I want to add a up arrow in the cell for the value 0, down arrow for the
value 0 and horizontal line (neutral) for value =0.
I tried to implement the above by using the standard formula but could not
do it.
Please advise how it can be done.
Mine Fav Formula this week is
=COUNTIF(A$3:A3,A3)
It resolved my headache...Give ranking n order number for repetitive
values
Love tht one
--
--
Some important links for excel users:
1. Follow us on TWITTER for
Hello,
Guys Need your help urgently
please
Regrads
-- Forwarded message --
From: lucky singh lucky60...@gmail.com
Date: Tue, Jan 18, 2011 at 10:51 AM
Subject: need help
To: excel-macros@googlegroups.com
Hi Guys need your help,
I have 25 agenst overall I have to record
29 matches
Mail list logo