W'd have a better understanding if a sample file is provided.
Thanks,
On Wed, Feb 19, 2014 at 9:33 AM, MLT wrote:
> I'm trying to get a feel for the "architecture" of this scenario:
>
> - Sheets are setup with hundreds of rows, headers are: item #, type and
> color (just 3 for simplicity's sa
Dear Mahesh
Good one
How to change date format.I want date format 5-Feb-2014.
Warm Regards
Amar
On Tue, Feb 18, 2014 at 9:35 PM, Mahesh Parab wrote:
> Hi Anil
>
> PFA workbook, you don't have to use calendar control.
>
> Regards
> Mahesh
>
>
> On Mon, Feb 17, 2014 at 4:46 PM, Swapnil Pala
I'm trying to get a feel for the "architecture" of this scenario:
- Sheets are setup with hundreds of rows, headers are: item #, type and color
(just 3 for simplicity's sake).
- I need a count of how many rows (items) meet criteria in both the "type" and
"color" columns.
- The criteria for th
Hi Abhishek
Try : UDF mention on below link
http://jonvonderheyden.net/excel/displaying-autofilter-criteria/
Regards
Mahesh
On Tue, Feb 18, 2014 at 8:22 PM, abhishek agarwal <
abhishekagarwal...@gmail.com> wrote:
> Dear Sir,
>
> Please help me out i need some help
> i need that if i choose som
Hi Prabhakar
perhaps you can use,
=DATE(YEAR(H2)+60,MONTH(H2),DAY(H2))
Regards
Mahesh
On Tue, Feb 18, 2014 at 3:54 PM, Ashish Bhalara
wrote:
> Dear Prabhakar, see the attached file to know the retire age as per your
> example
>
>
> On Tue, Feb 18, 2014 at 2:50 PM, wrote:
>
>> Hi Team,
>>
>> I
Ashish - thank you for posting. I receive a #value! error in the distance
field. I am using Excel 2013, any assistance is greatly appreciated.
On Saturday, February 25, 2012 8:01:12 AM UTC-5, ashish wrote:
> Hi Group
>
> Try this udf it will help you in finding the time and distance between
Dear Sir,
Please help me out i need some help
i need that if i choose some option in filter the header comes out from
that name
kindly please see the example
Raw Data:-
Colour Red Yellow Green pinky Brown
If i filter like that
Colour pinky Brown
So result comes out like that
*Colour,
Dear Prabhakar, see the attached file to know the retire age as per your
example
On Tue, Feb 18, 2014 at 2:50 PM, wrote:
> Hi Team,
>
> I need your help to find out date of retirement with simple formula in
> attached excel file.
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do y
Hi Team,
I need your help to find out date of retirement with simple formula in
attached excel file.
--
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 RUL
Hi,
PFA file for solution.
Regards,
Swapnil.
On Tue, Feb 18, 2014 at 1:41 PM, wrote:
> Dear Team,
>
> I have file where i need to find out when the employee is compelteing 60
> Years. Please refer attached file & Help.
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna
Hi Abhi,
Thanku so much for the clarification.
On Monday, February 17, 2014 7:41:40 PM UTC+5:30, Abhi wrote:
>
> It's from the same form control toolbox you have picked the option button
> from. Upon hovering the mouse pointer over the control, it says "Group Box
> (Form Control)". You pick the
Dear Team,
I have file where i need to find out when the employee is compelteing 60
Years. Please refer attached file & Help.
--
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.co
12 matches
Mail list logo
