Dear Vabs Brother
Its really cool formula which you have sent me… There was a glow in my face
Thanks very very muchfor helping excel enthusiasts
voluntarily !!
Regards
Amar
On Tue, Apr 29, 2014 at 8:56 PM, Vaibhav Joshi wrote:
> Hi,
>
> PFA
>
> Cheers!!
>
>
> On Tue, Apr 29, 2
Dear Ganesh & Ravinder,
I am also have this issue.
I saw your attachments, i don't know how to use this...
Kindly give a brief explanation.
On Sun, Apr 27, 2014 at 11:48 AM, Ganesh N wrote:
> Hi Yadav,
>
> you can also use this. Just put the data files in separate folder and put
> the path
Dear Ganesh,
Thank you...
Now i understood...
On Wed, Apr 30, 2014 at 11:33 AM, Ganesh N wrote:
> HI Kannan,
>
> There is In-build option in excel to show the duplicates. Please find the
> below steps.
>
> Home->conditional formatting->highlight cells rules->Duplicate value (you
> can create
I think Ganesh reply is correct if you just want to show the duplicates.
On Wednesday, 30 April 2014 11:33:55 UTC+5:30, Ganesh N wrote:
>
> HI Kannan,
>
> There is In-build option in excel to show the duplicates. Please find the
> below steps.
>
> Home->conditional formatting->highlight cells rul
HI Kannan,
There is In-build option in excel to show the duplicates. Please find the
below steps.
Home->conditional formatting->highlight cells rules->Duplicate value (you
can create whatever format u want to show the duplicate values)
Thanks & Regards,
Ganesh N
On Wed, Apr 30, 2014 at 11:27 A
so do you want to remove duplicates ?
On Wednesday, 30 April 2014 11:27:23 UTC+5:30, pappu wrote:
>
> Dear Friends,
>
> Please find the attached file of excel, I have a doubt in that excel.
>
> I checked the excel there is no formula and VBA coding but it is showing
> duplicates.
>
> How to do
Dear Friends,
Please find the attached file of excel, I have a doubt in that excel.
I checked the excel there is no formula and VBA coding but it is showing
duplicates.
How to do this in other excel... Please help me
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
Hi
Try this way
http://www.jkp-ads.com/articles/Excel2007FileFormat01.asp
Regards
Ashish Koul
On Tue, Apr 29, 2014 at 9:32 PM, Rob Flott wrote:
> For whatever reasons the size of my ActiveX ListBox expands and shrinks on
> an inconsistent basis forcing me to use the Forms ListBox instead.
>
>
Dear Sir,
countif function creating more violation for huge data range. is there any
possible to overcome or use any other function.
please guide me...
thanks...
On Tuesday, 29 April 2014 23:39:09 UTC+5:30, renuka chari wrote:
>
> Dear sir,
>
> thank you so much.your
Dear sir,
thank you so much.your given a great help..
On Tuesday, 29 April 2014 22:03:02 UTC+5:30, Vabz wrote:
>
> Hi
>
> PFA alternate method using formula & help sheet.
>
> Thanks
>
>
> On Tue, Apr 29, 2014 at 8:57 PM, renuka chari
> > wrote:
>
>> Dear sir,
>>
>> Thank you so
For whatever reasons the size of my ActiveX ListBox expands and shrinks on
an inconsistent basis forcing me to use the Forms ListBox instead.
The problem I have with the Forms ListBox is the small font.
1. Is there any way to change the font size within the Forms - ListBox?
2. If not, is the
Dear sir,
Thank you so much for your time and effort into problem.
my dashboard having huge no of sheets and if i make pivot sheet then my
workbook size is increasing more i was applied your formula earlier itself.
but i need even better solution. and my dash board data range is not
constant i
Hi,
PFA
Cheers!!
On Tue, Apr 29, 2014 at 5:01 PM, amar takale wrote:
> Dear friends
>
> I required output through vlookup from different table but it is
> possible only for one table.How to get all numbers from each table
> with data validation.PFA sheet.
>
> Pls suggest me any idea or other
Thank you Paul !!!
Regards
Eugene
On Mon, Apr 28, 2014 at 9:31 PM, Paul Schreiner wrote:
> Any place you have:
> Sheets(
>
> add the workbook name:
> Workbooks("Firstfile").Sheets(
>
> For the workbook that contains the code, you can use:
> Thisworkbook.Sheets(
>
>
> *Paul*
> --
Thanks Vabz. It was indeed very helpful and saved my time. Can i ask one
more thing (i m getting a bit greedy!!!)
In the sample file attached the list of employees is small and also dates.
is there a formula or way where the employee code and then dates would
automatically get pulled in (becaus
Its not possible to do without any help column.
Another way out is shown in attached file. Ref col E & F.
Thx
On Tue, Apr 29, 2014 at 2:34 PM, renuka chari wrote:
> Dear sir,
>
> i dont want to use pivot. i need only formula for offset or index is it
> possible...
>
> On Tuesday, 29 April 201
Hi
You can do with formula, check yellow colored area.
Thx
On Mon, Apr 28, 2014 at 10:40 PM, Vikas Agarwal wrote:
> Hi All,
>
> Need some help on excel calculations:
>
> I have a data of employee attendance (daily in/out time). The extract from
> timekeeping software does come in format for m
So... you're asking one or more of us to write the VBA code for you?
are you familiar with VBA?
what have you done so far?
Is the "base data" exactly how it comes from your timekeeping system?
the "times" are in a mixed format.
some are like: 23:04 (hours, minutes)
where others are like: 6.35
Dear Shrinivas,
Try using "Select Visible Cells" in customizng Quick Access Toolbar (QAB)
activate it select multipul cells and click on Select Visible Cells button
and then copy and past.
Please revert if it don't work.
On Tue, Apr 29, 2014 at 4:51 PM, Paul Schreiner wrote:
> ??
> That's what
Dear friends
I required output through vlookup from different table but it is
possible only for one table.How to get all numbers from each table
with data validation.PFA sheet.
Pls suggest me any idea or other formula.
Thanks
Amar
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you
??
That's what sorting does.
evidently, you have additional requirements that you've not included.
Paul
-
“Do all the good you can,
By all the means you can,
In all the ways you can,
In all the places you can,
At all the times you can,
To all the people yo
Please find attacehd Sheet
--
Shrini
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate thread titles. Poor thread titles, l
Dear sir,
i dont want to use pivot. i need only formula for offset or index is it
possible...
On Tuesday, 29 April 2014 11:20:39 UTC+5:30, Vabz wrote:
> Hi
>
> You can do using Pivot Table, see attached file.
>
>
>1. In the Pivot Table, click the drop down arrow in the RowLabels
>fi
23 matches
Mail list logo