xcel-macros@googlegroups.com [mailto:excel-macros@
> googlegroups.com] *On Behalf Of *Rabindra Thapa
> *Sent:* 20 September 2017 03:46
> *To:* excel-macros@googlegroups.com
> *Subject:* Re: $$Excel-Macros$$ Help Req.
>
>
>
>
>
> Last Date
>
> =INDEX(Sheet1!$C:$C,MA
Last Date
=INDEX(Sheet1!$C:$C,MATCH($A2,Sheet1!$A$2:$A$11270,0)+(COUNTIF(Sheet1!$A:$A,$A2)))
Second Last Date
=INDEX(Sheet1!$C:$C,MATCH($A2,Sheet1!$A$2:$A$11270,0)+(COUNTIF(Sheet1!$A:$A,$A2))-1)
if need for quantity wise, have to use vba
*Regards,*
*For quick responds click here for Message *
=RIGHT(B3,2)
*Regards,*
*For quick responds click here for Message *
On Sat, Sep 16, 2017 at 7:17 PM, Neeraj Gmail
wrote:
> Dear experts,
>
>
>
> Kindly find the sheet I want to put last two entries against Indus ID, can
> we solve with an excel formula
>
>
>
>
>
> --
> Are you =EXP(E:RT) or
Dear Prabhu,
THANKS A LOT.
On 29 July 2013 20:41, Prabhu Pinky wrote:
> Sumif - used to sum the range by checking single condition.
> Sumifs - used to sum the range by checking multiple conditions.
>
> Countif - used to count the range by checking single condiyion.
> Countifs - used to count th
Dear Rajasekhar,
THanks
On 29 July 2013 21:00, Rajasekhar Praharaju
wrote:
> Hi Ashish,
>
> Just go through this link... you have good examples...
>
> http://chandoo.org/wp/2008/11/12/using-countif-sumif-excel-help/
>
> Thanks,
> Raj
>
>
> On Mon, Jul 29, 2013 at 8:41 PM, Prabhu Pinky wrote:
>
>
Hi Ashish,
Just go through this link... you have good examples...
http://chandoo.org/wp/2008/11/12/using-countif-sumif-excel-help/
Thanks,
Raj
On Mon, Jul 29, 2013 at 8:41 PM, Prabhu Pinky wrote:
> Sumif - used to sum the range by checking single condition.
> Sumifs - used to sum the range by
Sumif - used to sum the range by checking single condition.
Sumifs - used to sum the range by checking multiple conditions.
Countif - used to count the range by checking single condiyion.
Countifs - used to count the range by checking multiple conditions.
On Jul 29, 2013 8:28 PM, "Ashish Kumar" w
Dear seniors,
How can we use sum & sumifs , countif & countifs. and what is the diffrence
between. pls explain with formula and example. pls help me.
thanks
Ashish
--
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
** **
>
> ** **
>
> Regards
>
> ** **
>
> *Syed Azeem*
>
> ** **
>
> ** **
>
> ** **
>
> ** **
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *neeraj chauhan
> *Sent:* Wednesday, December 12, 2012
Subject: $$Excel-Macros$$ Help req.
Dear Experts,
kindly find the attached sheet. i want to make the conditional format,
but how to make. revert me
--
Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate thread titles. Poor
Dear Neeraj,
Pl find attached.
Regards,
Gawli
On Wed, Dec 12, 2012 at 12:28 PM, neeraj chauhan wrote:
> Dear Experts,
>
> kindly find the attached sheet. i want to make the conditional format, but
> how to make. revert me
>
> --
> Join official Facebook page of this forum @
> https://www.facebo
Dear Experts,
kindly find the attached sheet. i want to make the conditional format, but
how to make. revert me
--
Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgen
Correction:
the macro shd be :
Sub Insert2Rows()
' siti Vi / jakarta, 29 Jun 2011
'---
Dim RNG As Range, r As Long
Set RNG = ActiveSheet.Cells(1).CurrentRegion.Offset(1, 0)
For r = RNG.Rows.Count To 2 Step -1
*RNG(r, 1).Resize(2, 1).EntireRow.Inse
use this code
Sub InsertRows()
Dim WkSht As Worksheet
Dim Rng As Range
Set WkSht = ThisWorkbook.Worksheets("Sheet1")
For x = 2 To WkSht.Range("A65536").End(xlUp).Row
If WkSht.Range("A" & Trim(Str(x))) <> "" Then
Application.StatusBar = "Inserting Rows on Row : " & Trim(Str(x + 1))
WkSht.Rang
Sub Insert2Rows()
' siti Vi / jakarta, 29 Jun 2011
'---
Dim RNG As Range, r As Long
Set RNG = ActiveSheet.Cells(1).CurrentRegion.Offset(1, 0)
For r = RNG.Rows.Count To 2 Step -1
If r Mod 2 > 0 Then RNG(r, 1).Resize(2, 1).EntireRow.Insert
Next
En
*Hi ,*
*
*
*
*
*Please help me to make simple dashboard to modified .*
*
*
*for reference see attachment,*
*
*
*
*
*thanks in adv..*
--
Regards
Rakesh Sharma
--
--
Some important links for excel users:
1. Follow us o
=sum(*Your_range*)/(COUNT(*Your_range*)-COUNTIF(*Your_range*,0))
On Thu, Oct 7, 2010 at 8:02 PM, Dilip Pandey wrote:
> Dear Mr. Rao,
>
> Please find the solved spreadsheet attached with this email. I have used
> SumProduct and Count functions to solve the query. Let me know if this
> helps :)
Dear Mr. Rao,
Please find the solved spreadsheet attached with this email. I have used
SumProduct and Count functions to solve the query. Let me know if this
helps :)
Best Regards,
DILIPandey
On Fri, Oct 1, 2010 at 12:08 AM, NRao Mynampati
wrote:
> Hi experts,
> how to eleminate zeros while
Hi experts,
how to eleminate zeros while selective range for average
function.Please find the attachement here fro your reference.
Regards,
Rao
--
--
Some important links for excel users:
1. Follow us on TWITTER for
19 matches
Mail list logo