Hi All
Reached out to seek help on my query as given below. Please
provide possible support.
Please find attached excel which has two tab
There is dropdown in Tab 1 - Chapter ID and Score
There are two columns in Tab 2 - Chapter ID and Score
When there is a match between Chapter ID from the dropd
bcoz it will be calculated for 360 days/year
no problem just go for this simple technique
=enddate-startdate+1
From
Naveenkumar
On Wed, Feb 12, 2014 at 10:07 AM, Shankar Bheema wrote:
> Thank you naveen for providing solution
>
> Wherein, the difference between dates from 01-01-2014 to 31-01-
Thank you naveen for providing solution
Wherein, the difference between dates from 01-01-2014 to 31-01-2014 is 31
days, but with the formula it is showing 30 days just short of 1 day. How
can I get the one day added to that column
On Tue, Feb 11, 2014 at 6:03 PM, Naveen Kumar M N <
naveenkumarm
Dear Shankar,
Pl find attached.
Warm Regards,
Gawli Anil.
On Mon, Feb 10, 2014 at 2:27 PM, Shankar Bheema wrote:
> Dear all,
>
> I attached an excel workbook which contains 3 worksheets. worksheet1 is
> named as Members worksheet2 is with membername and worksheet 3 is also named
> after the me
Dear all,
I attached an excel workbook which contains 3 worksheets. worksheet1 is
named as Members worksheet2 is with membername and worksheet 3 is also
named after the member
how can obtain When the member worksheet is filled the corresponding
membernamed worksheet also filled.
how to obtain th
Dear Experts
I have attached an excel file peratining to payroll situation. I need to
identify in one line when a new headcount is added and when a vacancy is
created preferably through a formula.
Your help is much appreciated.
Thanks
Umar
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And
Dear Pravin,
Solution is Perfect as like me.How to do it, any logic for code (true &
false) I will also try for 4th chart.And one more Chart is movable from
here to there Can I fixed this one place.
Thanks again
Amar
On Fri, Dec 14, 2012 at 10:38 AM, Pravin Gunjal wrote:
> *Hi Amar,*
> *
> *
Hi Vikas,
Answer (a): Use the Shortcut *" Alt + ; "
Apply Filter ==> Select Data ==> Alt + ; ==> Copy ==> Paste*
Rgds,
Maries
On Mon, Jun 20, 2011 at 12:00 PM, Vikas Agarwal wrote:
> Hi All,
>
> I need help on two things:
>
> a) I have filtered data from a large range (say A1 to A20).
Hi Vikas,
Ans For 1 Question Please Select Data after Filter & Press Ctrl+Alt+L then
Copy & Paste
For 2nd Question Please send sample data
Thanks & Regards
Anil Kumar
113784
On Mon, Jun 20, 2011 at 1:00 AM, Vikas Agarwal wrote:
> Hi All,
>
> I need help on two things:
>
> a) I have filte
Hi All,
I need help on two things:
a) I have filtered data from a large range (say A1 to A20). When in
copy and paste a formula in visible cells, excel 2007 throws error and
copies data in the entire range instead of only visible cells. How do i copy
and paste only in visible cells.
b) Is
hi azeema
can you tell us in which format you want the output
On Wed, Jun 15, 2011 at 11:03 PM, Azeema Faizunnisa wrote:
> thanks everyone for offer of help. Here is the sample data.
>
> On Wed, Jun 15, 2011 at 1:31 AM, Venkatesan c
> wrote:
> > Hi Azeema,
> > Send the sample data and some on
thanks everyone for offer of help. Here is the sample data.
On Wed, Jun 15, 2011 at 1:31 AM, Venkatesan c wrote:
> HiĀ Azeema,
> Send the sample data and some one will assist the query..
> Best Regards,
> Venkat..
>
>
> On Wed, Jun 15, 2011 at 2:38 PM, Azeema Faizunnisa wrote:
>>
>> I have a tabl
Hi Azeema,
Send the sample data and some one will assist the query..
Best Regards,
Venkat..
On Wed, Jun 15, 2011 at 2:38 PM, Azeema Faizunnisa wrote:
> I have a table in excel of # of employees by age, sex and category of
> employment. The ROWs have three diff categories by sex and the COLU
can you attach the sample workbook
On Wed, Jun 15, 2011 at 2:38 PM, Azeema Faizunnisa wrote:
> I have a table in excel of # of employees by age, sex and category of
> employment. The ROWs have three diff categories by sex and the COLUMNS
> have age (5 10-year age groups). Each cell provides the
I have a table in excel of # of employees by age, sex and category of
employment. The ROWs have three diff categories by sex and the COLUMNS
have age (5 10-year age groups). Each cell provides the number
(frequency) of employee for a particular age group and job category
and sex!! I would like to c
Hi Experts,
Basically i have 4 different workbooks data with same format i will
consolidate all the 4 work books and apply filter
and go to
Column AH, and filter by X category and move them to new sheet and
rename that new sheet as In active
like wise ill perform the same for these four
Hello Group Members, Is there any separate formula to take selcted
characters from one cell for Exp. from Cell which contains
031031263089W01, I want only 031263089. I gone from Right & Left
Function But it's Little bit lengthy procedure. Please suggest.
--
--
Can any one solved my problem??
Malek Sarfraj
DISCLAIMER:
Please note that this e-mail and its attachments are intended for the named
addressee only and may contain information that is confidential and privileged.
If you have by coincidence or mistake or without specific authoriza
18 matches
Mail list logo