Hi Vinod,
There is no workaround to filter twice in one spreadsheet in Excel
2003.
Also,In Excel 2007, you will have to use "Format as table" style to
apply filter to selected range.
To use Format as Table, Just select the range and apply any table
format from the dropdown and it will automatica
Hi Ayush,
I could put filter to one selected range and later when i want to put to
other range the 1filter disappeared. Note that i am using 2003.
Regards,
Vin
On Sun, Apr 11, 2010 at 11:37 AM, Ayush wrote:
> Hi Vinod,
>
> It is very simple. Just select the 1st range and apply the filter and
Hi Vinod,
It is very simple. Just select the 1st range and apply the filter and
same for 2nd range.
Please let me know if you have more questions.
Best regards,
Ayush Jain
Group Manager
On Apr 11, 10:16 am, vinod rao wrote:
> Hi Vikas,
> How did you do this?.
> Regards
> Vin
>
> On Wed, Apr 7,
I am posting the first idea :-
1) There should be an inbuilt feature of converting number into words.
2) Vlookup searches only in leftmost column of range, why not
rightmost or middle column ?
Now its your turn :)
On Apr 11, 10:59 am, Ayush wrote:
> Dear members,
>
> Most of us work in excel da
Dear members,
Most of us work in excel daily and lot of things come in mind like
"This is missing in Excel" , "Microsoft should add this feature in
excel" , "This feature can be better", and many more ideas..
I want you to share such ideas, bugs, suggestions, improvements,
weaknesses of excel
Hi Vikas,
How did you do this?.
Regards
Vin
On Wed, Apr 7, 2010 at 7:00 PM, Vikas Chouhan wrote:
> Hi,
>
> Go format as table,
>
> On Wed, Apr 7, 2010 at 6:23 PM, Jai wrote:
>
>> Dear All Members.
>>
>> How can put the filter 2 times in One Excel file .
>>
>> --
>> Thanks For Mail.
>>
>> --
>>
i have to add/insert new columns in D and E column; to translate date
data of column B ("periode")
to date data-type; since the date data in B column are mostly written
in text data-type.
formula in D column
=IF(B5="","",DATEVALUE(IF(ISNUMBER(FIND("to",B5)),LEFT(B5,8),B5)))
formula in E column
=IF(
Hi All,
Please help me in Learning Excel Macros, Pivot Table, ...is
there any Ebooks you have got which you can mail me would be a
help.
Also i m working in Workforce Management wherein we need to forecast the
call volume...please help me with it too
Looking
dim sht as worksheet
for sht in activeworkbook.worksheets
if lcase(sht.name) = "budget 2010" then
exit sub ' (exit function) if the procedure is a function
procedure)
end if
next
On Apr 11, 12:51 am, vsoler wrote:
> Hello,
>
> how, in a module, can I possibly know if a given sheet,
Sub a()
Dim i As Integer
Dim K As Boolean
K = False
For i = 1 To Worksheets.Count
If Worksheets(i).Name = "Budget 2011" Then
MsgBox "Sheet" & (i) & " IS Budget 2010"
K = True
Exit For
End If
Next i
If K = False Then
MsgBox "Budget 2011 Sheet does not exits"
End If
End Sub
On Sat, Apr 10,
Hello,
how, in a module, can I possibly know if a given sheet, say "Budget
2010" exists?
thank you for your help
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http:
Hi Grace,
Here is the latest version, with summary per code and two bugs
removed...
Good luck. Thanks for feedback.
cu
Paul Willekens
'===
Sub CalcTime()
Dim cAZ
Dim cCode
Dim cDatum
Dim cOldAZ
Dim cOldCode
Dim cOldDatum
Dim c
hi shashank,
thts wrong dude..
you just put vlookup...
but the data has got townwise, datewise rateswhich differs
reg
Praveen
On Sat, 10 Apr 2010 15:04:10 +0530 wrote
>HI Praveen
Please find the Sorted data
>
>--- On Sat, 10/4/10, Praveen kumar wrote:
>
>From: Praveen kumar
>
13 matches
Mail list logo
