Hi Ganesh,
Use the below formula.
For Forecast 1 =SUMPRODUCT((MONTH($B$3:$DC$3)=MONTH(B$10))*$B$4:$DC$4)
For AHT
=SUMPRODUCT((MONTH($B$3:$DC$3)=MONTH(B$10))*$B$5:$DC$5)
Regards,
Excel Beginner
From: excel-macros@googlegroups.com [mailto:excel-macros
Hi Ashish,
Use this " =SUMPRODUCT(1/COUNTIF(A2:A595,A2:A595)) "
Regards,
Excel Beginner
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Ashish Kumar
Sent: Monday, September 23, 2013 11:49 AM
To: ex
Hi Chandra Sekar ,
Use the below formula.
=ROUNDUP(SUM(1/COUNTIF(B2:B15,B2:B15)*IF(A2:A15=C2,1,0)),0) with
ctrl+shift+enter.
Regards,
Excel Beginner
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of
Hi Nemi Gandhi,
Try the below formula.
=INDEX(D4:AO41,MATCH(F2&F3,D4:D41&E4:E41,0),MATCH(G2&G3,D4:AO4&D5:AO5,0))
with ctrl+shift+enter.
Regards,
Excel Beginner
-Original Message-
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.c
Hi,
Please find the attachment.
Regards,
>>Excel Beginner<<
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of ha...@mst.edu
Sent: Tuesday, July 30, 2013 11:07 PM
To: excel-macros@googlegroups.com
Subject: $$
ead of "N/A" it should take the previous date closing
> price.
>
> Please help.
>
> regards
> GIRISH
>
>
>
> On 20 March 2013 09:00, अनिल नारायण गवली wrote:
>
>> Dear G.Rishi,
>>
>> Pl see the attached sheet.
>>
>> Warm
Hi Girish,
Use this
=IF(VLOOKUP(G$4,$A$4:$B$15185,2,0)=$F5,VLOOKUP(G$4,$A$4:$C$15185,3,0),"") in
cell G5 and copy down and right.
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of M S GIRISH
Sent: Tuesday, March 19, 2013 10:55 PM
To:
Hi amar,
Please find the attachment.
*Regards,*
*
*
*Excel Beginner*
On Mon, Mar 4, 2013 at 11:50 AM, amar takale wrote:
> Dear Experts Team
> I have small query in excel,i give detail information in Attached sheet
> Pls sloved my query
> Amar
>
> --
> Are y
iving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros?hl=en.
> For more options, visit https://groups.google.com/groups/opt_o
is group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros?hl=en.
> For more options, visit https://groups.
Hi Dhaval,
Find the attachment.
--
*Regards,*
*
*
*Excel Beginner*
On Tue, Feb 12, 2013 at 1:42 PM, Dhaval Shah wrote:
> Dear Friends
>
> pls refer my sheet i want a formula solution
>
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you w
bscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros?hl=en.
> For more options, visit https://groups.google.com/groups/opt_out.
>
>
>
--
*Regards,*
*
*
*Excel Beginner*
Hi Yogananda,
I had given the solution to your query, please find the
attachment.
--
*Regards,*
*
*
*Excel Beginner*
On Wed, Jan 30, 2013 at 10:37 PM, yogananda muthaiah <
yogananda.mutha...@gmail.com> wrote:
>
> Dear All,
>
> I would a search engin
Hi Hemanath,
You can sum to be included "No Of Days Present".
--
*Regards,*
*
*
*Excel Beginner*
On Tue, Jan 29, 2013 at 10:50 PM, hemanath dhanasekar
wrote:
> Thanks the formula is working, but I dont see any changes in "No Of Days
> Present&quo
Hi Hemanath,
Use the following formula or more clarity find the
attachment.
=COUNTIF(*C3:AG3*,"H")*0.5
--
*Regards,*
*
*
*Excel Beginner*
On Tue, Jan 29, 2013 at 9:51 PM, hemanath dhanasekar wrote:
> Gawli,
>
> This is
Hi Deepak,
Below mentioned formula used of worksheet cell "B2" or find
the attachment.
=ROUNDUP(SUM(IF(Data!
B2:B12=Summary!A2,1/COUNTIF(Data!E2:E12,Data!E2:E12),0)),0)
--
*Regards,*
*
*
*Excel Beginner*
On Thu, Jan 17, 2013 at 11:16 AM, Deepak Rawat wrote:
> HI
Hi Amar,
Below is the solution to your needs or check the attachment.
=--MID($C$2,SEARCH(B6,$C$2)+(LEN(B6))+3,FIND("""",$C$2,SEARCH(B6,$C$2)+(LEN(B6)+3))-(SEARCH(B6,$C$2)+(LEN(B6)+3)))
--
*Regards,*
*
*
*Excel Beginner*
On Thu, Jan 17, 2013 at 7:03 PM, amar t
sponsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To post to this group, send email to excel-macros@googlegroups.com.
> To unsubscribe from this group, send email to
> excel-mac
Hi,
Please find the attachment.
--
*Regards,*
*
*
*Excel Beginner*
On Thu, Jan 10, 2013 at 2:52 PM, Smitha S R wrote:
> Hi,
>
> PFA the file which shows distance in KMS between different places.
> First Table 'Data' mentions the kms from one place to anothe
Hi Jocky,
I have been given to simple way solution. Please find the
attachment.
--
*Regards,*
*
*
*Excel Beginner*
On Fri, Jan 4, 2013 at 4:59 PM, jocky Beta wrote:
> Hi Team,
>
> I have attached one excel sheet in wich i need to set the formula for the
> pe
Hi Neeraj,
Pls check attachment.
--
*Regards,*
*
*
*Excel Beginner*
On Sat, Dec 29, 2012 at 3:46 PM, neeraj chauhan
wrote:
> DEAR Experts,
>
> i am waiting for the revert
>
> -- Forwarded message --
> From: neeraj chauhan
> Date: Sat, Dec
Hi Amit,
Please find the attachment.
--
*Regards,*
*
*
*Excel Beginner*
On Sat, Dec 22, 2012 at 4:56 PM, Amit Gandhi wrote:
> Hi Experts
>
> I am attaching an excel file, where I have applied LOOKUP/INDIRECT
> function in sheet "backup". But its very slow i
Hi Manjunath,
solved your query, please find the attachment.
--
*Regards,*
*
*
*Excel Beginner*
*
*
On Thu, Dec 13, 2012 at 8:45 PM, Manjunath Narayanappa <
manjunath.narayana...@aon.co.uk> wrote:
> Hi experts,
>
>
>
> I want to calculate no of
Hi Raghu,
please find the attachment.
--
*Regards,*
*
*
*Excel Beginner*
*
*
On Tue, Dec 11, 2012 at 5:59 PM, raghunandan rallapalli <
raghunandan.rallapa...@gmail.com> wrote:
> sir,
> I need a formula for total sum of each account no wise as given in e
d to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To post to this group, send email to excel-macros@googlegroups.com.
> To unsubscribe from this group, send email to
> excel-macros+unsubscr...@googlegroups.com.
> Visit this group at http://groups.google.com/group/exc
Hi,
Please find the attachment.
--
*Regards,*
*
*
*Excel Beginner*
*
*
On Thu, Dec 6, 2012 at 11:40 PM, JMac wrote:
> I've got a tracking sheet with 6 columns, each row being an entry for
> equipment maintenance. Column C contains the serial number of the
> equipment.
Hi Noorain Sir,
Below mentioned your requirement and find the attachment.
=IFERROR(VLOOKUP($I$5,INDIRECT("F"&SMALL(IF($F$5:$F$11=$I$5,ROW($F$5:$F$11)),ROW(A1))&":"&"$G$11"),2,0),"")
*Regards,*
*
*
*Excel Beginner*
*
*
Hi Jenny,
Use this =TEXT(B3,"dd/mm/")&" "&TEXT(C3,"hh:mm")
--
*Regards,*
*
*
*Excel Beginner*
*
*
On Thu, Nov 29, 2012 at 11:20 PM, JenIT wrote:
> My data is opened from a downloaded file. I do not have an import
> functions as
Hi Rajan sir,
Please find the attachment. I had been given to another
solution.
*Regards,*
*
*
*Excel Beginner*
*
*
On Sat, Nov 24, 2012 at 10:11 AM, Rajan_Verma wrote:
> *HI,*
>
> *As per your formula if you have 50 Rows you need 50 Index to do
Hi Rajan Sir,
please find the attachment.
*Regards,*
*
*
*Excel Beginner*
*
*
On Fri, Nov 23, 2012 at 10:51 PM, Rajan_Verma wrote:
> * *
>
> *Hi Group,*
>
> *
> here is a formula Practice , hope you will enjoy this,*
>
> * *
>
> *Suppose you ha
Hi Renu,
Please find the attachment.
--
*Regards,*
*
*
*Excel Beginner*
*
*
On Tue, Nov 20, 2012 at 10:20 PM, renuka chari wrote:
> hi Excel beginner,
> i don't know your name?
> but you gave me a wonderful solution
> thanks allot.
> but is th
Hi Viswanathan,
Pls find the attachment.
--
*Regards,*
*
*
*Excel Beginner*
*
*
On Wed, Nov 21, 2012 at 2:43 AM, Viswanathan Yoganathan <
viswanathan.yoganat...@asia.xchanging.com> wrote:
> HI,
>
> ** **
>
> In the attached excel, I need to
Hi Renu,
please find the attachment.
--
*Regards,*
*
*
*Excel Beginner*
*
*
On Mon, Nov 19, 2012 at 10:35 PM, Renukachari Kasee wrote:
> Dear experts,
> is there any solution for pick the step value in certain table?
>
> please see above attached workbook
&
Hi Karan,
use this CSE formula
"=INDEX($C$1:$C$8,SMALL(IF($A$1:$A$8&$B$1:$B$8=G3&H3,ROW($A$1:$A$8)),COUNTIFS($A$1:$A$8,G3,$B$1:$B$8,H3)))"
--
*Regards,*
*
*
*Excel Beginner*
*
*
On Wed, Nov 14, 2012 at 1:08 PM, Karan Singh wrote:
> Dear All,
>
> Ple
Hi shiva,
please find the attachment.
--
*Regards,*
*
*
*Excel Beginner*
*
*
On Fri, Nov 9, 2012 at 9:55 PM, Shiva Prasad wrote:
> Dear Champs,
>
> i have on excel one sheet when i mentioned values of percentages change
> the color of that cells.
>
> please hel
Hi Viswanathan,
please find the attachment.
--
*Regards,*
*
*
*Excel Beginner*
*
*
On Sat, Oct 27, 2012 at 3:06 AM, Viswanathan Yoganathan <
viswanathan.yoganat...@asia.xchanging.com> wrote:
> HI,
>
> ** **
>
> In the first column we have is
Hi Manoj,
please find the attachment.
--
*Regards,*
*
*
*Excel Beginner*
*
*
On Fri, Oct 26, 2012 at 11:59 AM, Manoj Kumar wrote:
> Dear Expert,
>
> Please help me to get the currect ans with attached file..
>
>
> Regard
> Manoj
>
> --
> Join offici
Hi Rajesh,
Find the attachment.
--
*Regards,*
*
*
*Excel Beginner*
*
*
On Fri, Oct 12, 2012 at 4:16 PM, Rajesh Agarwal wrote:
> Dear Sir
> How can i find odd one's in sheet 1 from sheet 2 and sheet 2 from sheet 1.
> Rgds
>
> --
> *Rajesh Kumar Agarwal*
Hi Shrini,
Find the Attachment.
--
*Regards,*
*
*
*Excel Beginner*
*
*
On Wed, Oct 10, 2012 at 5:53 PM, Shrinivas Shevde wrote:
> Dear All
>
> Is it possible to use Vlookup with multple conditio. i e.
> Can I get the value From Column E if All the column a,b,c,d matches
Hi Sriram,
Use this =SUBSTITUTE(A1,"!","") and you are change to the
special character.
--
*Regards,*
*
*
*Excel Beginner*
*
*
On Wed, Oct 10, 2012 at 4:02 PM, sriram ji wrote:
> Dear Excel Guru,
>
> Any formula for removing special character ex
Hi Ahmed,
Find the attachment.
--
*Regards,*
*
*
*Excel Beginner*
On Tue, Sep 25, 2012 at 3:27 PM, Ahmed Honest wrote:
> Dear All,
>
> Please find attach the Raw Data sheet from which I need to convert a
> Gregorian Date to a Hijri Date and pull out the Day, Mont
Hi sharad,
Find the attachment.
--
*Regards,*
*
*
*Excel Beginner*
On Sun, Sep 16, 2012 at 9:07 PM, sharad jain wrote:
> Dear Experts,
>
> Please help me in calculating operating days in the attached sheet.
>
> There are 2 contracts which will run after one aft
Hi Sharad,
Find the attachment.
--
*Regards,*
*
*
*Excel Beginner*
On Sun, Sep 16, 2012 at 9:07 PM, sharad jain wrote:
> Dear Experts,
>
> Please help me in calculating operating days in the attached sheet.
>
> There are 2 contracts which will run after
Hi Sundarvelan,
Use this CSE formula =MAX(IF(G2=A:A,E:E))
--
*Regards,*
*
*
*Excel Beginner*
On Fri, Sep 14, 2012 at 4:49 PM, Sundarvelan N wrote:
> Dear Friends,
>
> Please help me to find the latest date of a student.
> Thanks
> N.Sundarvel
Hi Amit,
First Select Your Data and Using this shortcut Key
>> Alt+A+A
--
*Regards,*
*
*
*Excel Beginner*
On Thu, Sep 13, 2012 at 5:37 PM, Amit Desai (MERU)
wrote:
> Please let me know if we have an easier way for sorting data all
> together in all sheet h
>
> Hi Dhananjay,
>
>
Please Find the Attachment.
> Regards,
>
>
Excel Beginner
>
>
> I need a solution as per my query in attached file.
>>
>> Pl. revert in case of any clarification or any confusion.
&g
Hi Dhananjay,
Please find the attachment.
Regards,
Excel Beginner
On Mon, Sep 10, 2012 at 12:32 AM, Dhananjay Pinjan wrote:
> Dear Experts,
>
> I need a solution as per my query in attached file.
>
> Pl. revert in case of any clarification or any confusi
47 matches
Mail list logo
