Hi,
The problem is not the sheet names, but the indirect refering to a date, which
is really just a date code, not a date as displayed.
Regards - Dave.
Date: Thu, 13 Jan 2011 23:08:24 -0800
Subject: Re: $$Excel-Macros$$ Formula of the week - share your best formula
From:
I agree with Dave MS-EXL_LEARNER. It's not about favourite function but
the best formula, which means combination of existing functions, functions
with arrays, nested functions. i.e. THE BEST PURPOSEFUL FORMULA - we ever
came across.
--
Excel VBA Interview
Hi Noorain,
Its good, but I have a situation here were for A i have 2 industry names
mentioned by and both have same values. how can i delete an entry an dkeep one
entry.
eg
A Professional 2000
A Service 2000
A total 2000
B Manufacturing 4000
B
Hi Dave,
How can solve it. Please give ur valauble suggestion..
Thanks,
Noorain Ansari
On Fri, Jan 14, 2011 at 1:34 AM, Dave Bonallack
davebonall...@hotmail.comwrote:
Hi,
The problem is not the sheet names, but the indirect refering to a date,
which is really just a date code, not a date as
On 1/14/11, OpenExcel.com 26may.1...@gmail.com wrote:
I agree with Dave MS-EXL_LEARNER. It's not about favourite function but
the best formula, which means combination of existing functions, functions
with arrays, nested functions. i.e. THE BEST PURPOSEFUL FORMULA - we ever
came across.
Dear All,
Really grateful to all of you.
Thanks a lot for your quick appropriate response.
Thanks once again to all of you EXCEL-MACRO GROUP.
Regards
Kalyan
On Fri, Jan 14, 2011 at 10:06 AM, Manoj kumar
manoj.vishwakarma...@gmail.com wrote:
See if this helps you out...
Regards,
Happy Makar Sakranti to all.. :)
Best Regards,
DILIPandey
On Fri, Jan 14, 2011 at 12:35 PM, vikas gupta vikas.63...@gmail.com wrote:
धन्यवाद
आप सब को भी मकर संक्रांति की शुभ कामनाये
विकास गुप्ता
On Fri, Jan 14, 2011 at 10:55 AM, Chandra Singh Bora chandu...@gmail.com
wrote:
*
Hi Noorian,
One option is to format the reference cell (with the date in it) as text, then
type in the date again, exactly as it appears on the appropriate sheet tab. You
also need to add single quotes around the sheet name, so the indirect function
looks like this:
INDIRECT('B6'!A:B) Without
Hi,
I would like to submit the following formula as one I like.
It performs a case-sensitive Vlookup, and is non-array.
=LOOKUP(2,FIND(A1,Sheet2!A:A),Sheet2!B:B)
A1 contains the lookup value
Sheet2!A:A is the lookup column
Sheet2!B:B is the return column
I hasten to add that this formula is
I used to know this but I can't remember how to identify the row
number and column number of the active cell. E.g
activecell.rows().count or something like that. Can anyone help?
Thanks
--
--
Some important links
Dave,
Why am I getting #NUM! with the formula? (See Attached)
Thank you.
John
On Fri, Jan 14, 2011 at 10:35 AM, Dave Bonallack
davebonall...@hotmail.comwrote:
Hi,
I would like to submit the following formula as one I like.
It performs a case-sensitive Vlookup, and is non-array.
Dave,
Why am I getting #NUM! with the formula? (See Attached)
Thank you.
John
On Fri, Jan 14, 2011 at 10:35 AM, Dave Bonallack
davebonall...@hotmail.comwrote:
Hi,
I would like to submit the following formula as one I like.
It performs a case-sensitive Vlookup, and is non-array.
Hello everyone,
I have 2 spreadsheets. One with raw data, the other is the one i need
the data in. When i copy the data across the dates change. In the
original spreadsheet, the data code is 40556, and when viewed as a
short date it is converted to 1/13/2011. However, the in the second
iS there any help?
I have a pivot table
how to use Or in two columns
I want to view all rows which
Column1 = cat Or column2 = cat
Not
Column1 = cat AND column2 = cat
By code or any way
Thanks!
--
Hi,
Add an helper column to your data Insert column after column 2 and
there put =IF(A2=cat,Cat,IF(B2=cat,Cat,))
This will put a Cat if there is cat in column1 or column2 then you
can base your pivot table on this column to get your solution.
Hope that helps,
Anand Kumar
On Jan 14, 2:23 am,
I found the issue. Plain copy-control mistake. He changed the add-in default
directory on his copy to another location, so it was not accessing xla file.
Thanks for the response though. Really appreciate it.
Mike
On Wed, Jan 12, 2011 at 9:22 PM, Paul Schreiner schreiner_p...@att.netwrote:
ActiveCell.Row
ActiveCell.Column
On Fri, Jan 14, 2011 at 10:34 PM, Barry N barrynau...@gmail.com wrote:
I used to know this but I can't remember how to identify the row
number and column number of the active cell. E.g
activecell.rows().count or something like that. Can anyone help?
Thanks
Hi David,
Excel support to date systems i.e. 1900 Date system 1904 Date system.
In your case, it seems that first spreadsheet is following 1900 Date system
second spreadsheet is following 1904 Date system.
The difference between the two date system is 1465 days i.e. 4 years One
day
You can
Hi Noorain,
Please use below formula:
=VLOOKUP(A7,INDIRECT('TEXT(B7,dd-mmm)'!A:B),2,0)
Regards
Upendra Singh
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of NOORAIN ANSARI
Sent: Friday, January 14, 2011 12:38 PM
To:
Hi John,
I opened your file, but don't get a #NUM error. I get '98' as expected. I tried
it in XL 2007 and 2003.
Regards - Dave.
Date: Fri, 14 Jan 2011 14:28:41 -0500
Subject: Re: $$Excel-Macros$$ Formula
From: johnasmit...@gmail.com
To: excel-macros@googlegroups.com
Dave,
Why am I
Hi David,
Sounds like your spreadsheets are using different calendars systems.
Excel can use the 1900 system or the 1904 system. 1900 is the default setting.
In XL2003, go to Tools, Options, Calculations Tab. There make sure that the
1904 thingy is unchecked.
Do the same for both workbooks.
In
21 matches
Mail list logo