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 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
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
=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
13 matches
Mail list logo
