Dear Paul,
one more thing your indirect formula is not working in master sheet,
would u please explain
thanks & regds
On Tue, Sep 27, 2011 at 6:50 PM, Paul Schreiner wrote:
> Well.. the =max() function will work to get the DATE,
> but using the match() function with the multi-row produces an er
Hello Friends,
I have attach the sheet which included two table
T1
T2
i want to change the T1 data to T2
Please help
Regards
Shashank
9422927499
--
--
Some important links for excel users:
1. Follow us on TWITTE
Dear Dguillett1,
your formula is working but some places its not working, why can u explain?
thanks
On Tue, Sep 27, 2011 at 7:27 PM, dguillett1 wrote:
> =INDEX(F36:IV36,0,MATCH(99,F36:IV36))
> =INDEX(F37:IV37,0,MATCH(99,F36:IV36))
> See attached
>
> -Original Message- Fr
Yes paul i need a macro please help
On Tue, Sep 27, 2011 at 6:50 PM, Paul Schreiner wrote:
> Well.. the =max() function will work to get the DATE,
> but using the match() function with the multi-row produces an error.
> So, I think we need to add a column (that could be hidden) to check multiple
Hi,
Something like this..
=IF(ISNUMBER(SEARCH("FL",IR3)),IR3,IF(ISNUMBER(SEARCH("FL",IS3)),IS3,IF(ISNUMBER(SEARCH("FL",IT3)),IT3,IF(ISNUMBER(SEARCH("FL",IU3)),IU3,""
The above formula check from Cell IR3 to IU3, if any match is found from the
starting cell then it stops the the remaining con
can you attach the sample workbook and mail it to
excel-macros@googlegroups.com
On Tue, Sep 27, 2011 at 11:41 PM, plus766 wrote:
> I have a spreadsheet where I've done an index match to return
> criteria. I have to match three or four columns to get the information
> that I need, so I have thr
I have a spreadsheet where I've done an index match to return
criteria. I have to match three or four columns to get the information
that I need, so I have three or 4 columns that either have the
information I need or a "NO" from the index match.
I need a formula to look at the columns and say, if
Hi
Please find the attached file with my solution as per my understanding of
the problem.
I have used helper column in F & G to get the data. And then by selecting
each data label seperately I have directed them to take values from helper
column.
Hope you get the solution or this is what you we
Send me the file and I’ll take a look
From: Jeff
Sent: Tuesday, September 27, 2011 12:56 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Create report & print based on cell value
I have a list that is used to track when people are issued uniforms.
I'd like to create a macro that
I have a list that is used to track when people are issued uniforms.
I'd like to create a macro that can look at the date in the cell that
indicates when they get their next set and prints out a list of all
employees where that date is past the current date.
My sheet has 4 columns - Employee Name
Please attach sample file
Chilexcel
2011/9/26 joseph camill
> How do I add percentages and values in a normal stack chart.
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips
I didn’t see a “like the above” and I answer many emails so please refresh my
memory and attach the file.
From: Mr excel
Sent: Monday, September 26, 2011 10:36 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Create worksheet from list
Mr.guillet..thanks for that great macro.
Attach your file
-Original Message-
From: JMac
Sent: Monday, September 26, 2011 7:32 PM
To: MS EXCEL AND VBA MACROS
Subject: $$Excel-Macros$$ Create report & print based on cell value
I have a list that is used to track when people are issued uniforms.
I'd like to create a macro that
Well.. the =max() function will work to get the DATE,
but using the match() function with the multi-row produces an error.
So, I think we need to add a column (that could be hidden) to check multiple
rows.
But, if the highlighting of PREVIOUS cells is an absolute requirement, then we
might as we
Thanks :)
Mvh
Kim Pedersen
Strand Vinduspuss
Tlf. +47 934 60 815
2011/9/24 dguillett1
> See Attached
>
> *From:* Urghhh
> *Sent:* Friday, September 23, 2011 2:33 PM
> *To:* excel-macros@googlegroups.com
> *Subject:* Re: $$Excel-Macros$$ When do my subscribers pay plan
>
> Hi
>
> Sorry
Hi Paul,
thanks for your help, and yes i required the latest date i.e. 22-Mar-11.
On Tue, Sep 27, 2011 at 5:41 PM, Paul Schreiner wrote:
> As I mentioned before,
> =MAX(F4:O4)
> will give you the maximum date.
>
> =INDIRECT("R3C"&MATCH(MAX(F4:O4),F4:O4)+5,FALSE)
> will give you the Rev #.
>
> As
I have a list that is used to track when people are issued uniforms.
I'd like to create a macro that can look at the date in the cell that
indicates when they get their next set and prints out a list of all
employees where that date is past the current date.
My sheet has 4 columns - Employee Name/
Dear Amit,
If you want to just convert data into vertical form. Follow these
steps:
-Copy your data using Ctrl+C
-Choose the cell where you want to paste your data
-Go to the Edit Menu and choose "Paste Special"
-In the paste special dialog box choose "All" and click the
"Transpose" option...and
Mr.guillet..thanks for that great macro.i had a situation same like the
above. A little change is that u had given example for a worksheet with
data.
i want to update all the worksheets as and when i enter new data into the
main sheet.i think it can be done using the On_enter worksheet event.can u
How do I add percentages and values in a normal stack chart.
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group
well friend i´m learning by recording and then studying the code, there are
many books, but i don´t like them very much, too much writing confuses, i
prefer to see "live" excel and study them and test them, i find very useful,
Ashish Koul blog and twitter, it´s being very useful to my learning, mos
21 matches
Mail list logo
