What I would like is under column D to be able to select one store
number at a time from the data sort filter. What I would like to do
is
have a VLookUp in cell “I8” for the range of store numbers in column
D and have the store name appear depending on what single store is
shown while using the
can you please share the sample with us so that we can try on the
above query.
Regards,
Rahul Gandhi
On May 12, 12:03 pm, uu uugan...@gmail.com wrote:
What I would like is under column D to be able to select one store
number at a time from the data sort filter. What I would like to do
is
Hi Uugandhi,
Its better if you could pls attach the file provided its not confidential.
Best Regards,
Haigreev
On 5/12/10, uu uugan...@gmail.com wrote:
What I would like is under column D to be able to select one store
number at a time from the data sort filter. What I would like to do
is
What I would like is under column D to be able to select one store
number at a time from the data sort filter. What I would like to do is
have a VLookUp in cell “I8” for the range of store numbers in column
D and have the store name appear depending on what single store is
shown while using the
Hi nino,
check my reply in the $$Excel-Macros$$ Maximum Date problem.
Thanks Regards
Sandeep
On Sun, May 9, 2010 at 1:12 PM, Ravi Megharaj ravi.megha...@gmail.com wrote:
You can concatenate Column A and Column B to get the unique value. Then do a
vlookup to get the exact value. Once
send a sample sheet buddy
On Sun, May 9, 2010 at 12:07 AM, nino nki...@gmail.com wrote:
hi,
does anyone have idea or solution to solve search over 2 columns range
where both criteria needs to be met.
e.g. if you have database with 3 columns. column A is account, column
B is cost centar and
You can concatenate Column A and Column B to get the unique value. Then do a
vlookup to get the exact value. Once performing this operation, you can
delete the concatenated column.
Hope this helps
Ta
Ravi
On Sun, May 9, 2010 at 12:04 PM, madhu nair madhuna...@gmail.com wrote:
send a sample
hi,
does anyone have idea or solution to solve search over 2 columns range
where both criteria needs to be met.
e.g. if you have database with 3 columns. column A is account, column
B is cost centar and column C is value.
I would like to search for value of specific account for specific cost
Hi Gaurav,
While VBA is great (and I use it often), I recommend only using VBA when you
absolutely need to. For starters, many users won't open an XLSM file for
security reasons. Second, there are many more people who can maintain Excel
formulas than there are those who can maintain VBA code.
Hi Gaurav,
See this solution, More productive and time saving.
Regards
Sandeep
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2.
Hi Gaurav,
See this solution, More productive and time saving.
Regards
Sandeep
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
Hello,
I have tried this for sometime now but maybe i'm missing something.
I'm trying to use VLOOKUP and the range that i'm searching in could
have multiple occurences of the lookup value. I want to get all the
instances of the lookup value. I have tried to use array formulas with
VLOOKUP and
'VLOOKUP PROBLEM WITH MULTI ITEM OR VALUE
'WORK FINE FOR DISTINCT ID/VALUE
Suppose we have client id along with purchase id,such as,if we have multiple
of client id
Then applying vlookup will not give required result.
Client ID
Purchase ID
uw001
cd001
uw002
cd002
uw003
cd003
uw004
Thanks for the help Shyam,
I have a similar code that would work through this problem but then
this does slow down a bit when i have around 1 line items to
search through. I tried yesterday and using arrays to loop through the
values does fasten the search considerably. I am refining the code
Thanks for your help Chris,
The implementation is great.
I would now look to convert this to a VBA function or subroutine.
Thanks again for your help.
Gaurav!!
--
--
Some important links for excel users:
1.
-Jan to
17-Jan16-Jan-09 11-Jan to 17-Jan17-Jan-09 11-Jan to 17-Jan18-Jan-09 18-Jan
to 24-Jan19-Jan-09 18-Jan to 24-Jan
Date: Sun, 10 Jan 2010 09:10:23 -0800
From: alokeshwar.tiw...@yahoo.com
Subject: Re: $$Excel-Macros$$ Vlookup-Dates
To: excel-macros@googlegroups.com
Please share
know we don't know.
From: Sachin Gohil sachin.go...@hotmail.com
To: excel-macros@googlegroups.com
Sent: Mon, 11 January, 2010 9:28:00 PM
Subject: RE: $$Excel-Macros$$ Vlookup-Dates
Its very simple data. For every date I want Mon-Sun for that date.
File 1
unknown unknowns. There are things we don't know we don't know.
From: Sachin Gohil sachin.go...@hotmail.com
To: excel-macros@googlegroups.com
Sent: Sun, 10 January, 2010 7:00:44 PM
Subject: $$Excel-Macros$$ Vlookup-Dates
Dear All,
I did a vlookup of dates
Hello Excel guru's,
I want data in the main sheet into the format provided in sheets
510,511 and 512 besides the main sheet,I have been using autofilter
option,by filtering period column and wages column and creating new sheets,
then using vlookup formula to pull the data into my reports
Thanks for the Reply,
But for the range it is not working. Please help me to fix it.
Regards,
Ashwin
--~--~-~--~~~---~--~~
--
Some important links for excel users:
1. Excel and VBA
--~--~-~--~~~---~--~~
--
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at
http://www.excelitems.com
2. Excel tutorials at
Dear Friends,
I m facing this problem in Excel 2007.
attached is the excel sheet, kindly help.
--
With Love,
Mahesh Bisht
--~--~-~--~~~---~--~~
--
Some important links for excel
i would like to add an example of what im trying to do. please let me
know how to add a file.
--~--~-~--~~~---~--~~
--
Some important links for excel users:
1. Excel and VBA
Dear All
Does anyone knows how to vlookup from multiple sheet, i got below mention
formula on net but its not working
=IF(ISNA(VLOOKUP(A2,Wrk1!$F:$G,2,0)),
IF(ISNA(VLOOKUP(A2,Wrk2!$F:$G,2,0)),
IF(ISNA(VLOOKUP(A2,Wrk3!$F:$G,2,0)),
VLOOKUP(A2,Wrk3!$F:$G,2,0)),
VLOOKUP(A2,Wrk2!$F:$G,2,0)),
Hi
I have one query.
I have data in two different sheets. Below are example for you.
*Data in sheet 1:*
Name Data Date No.
Su 12 1/1/99 123
gu 22 2/2/99 124
gg 33 3/3/00125
*Data
Dear Members
i have one problem
in one sheet there is data as
party name bill no. amount
there are 100s of party detail,one party may has many bill no
in another sheet
party name bill no.
Dear Group Member,
Can some one help me on attached file. I
wanted to get result from Data into summery by selecting agent name.
I wanted to done without Micro.
Regards,
Mudassar Razman
--~--~-~--~~~---~--~~
Visit the blog
401 - 427 of 427 matches
Mail list logo