Search:

Type: Posts; User: Sam_D_Ben; Keyword(s):

Page 1 of 6 1 2 3 4

Search: Search took 0.02 seconds.

  1. Replies
    2
    Views
    111

    Re: Conditional formula

    Recalled.
  2. Replies
    1
    Views
    107

    Re: Excel Performance Issue

    How about your previous question posted on (Aug 16th, 2019, 01:22 AM), did it got resolved ? Appreciate your feedback since its a kind of learning new things.
  3. Re: how to count and sum cells by color in excel

    If its for summing up,


    Public Function ASAPSumByCellColor(rngSource As Range, sColorIndex As Single) As Single

    Dim...
  4. Re: how to count and sum cells by color in excel

    Also i guess it can be downloded.
  5. Re: how to count and sum cells by color in excel

    Hey Fluff, I dint see your comment. I am sorry. :)
  6. Re: how to count and sum cells by color in excel

    I guess, ASAP is an Add-in utility, do you have this in Excel?
  7. Re: Return header value from a column of data in another worksheet

    Oh sorry, I dint see this.
  8. Re: Return header value from a column of data in another worksheet

    Or,

    <b>Excel 2013/2016</b><table cellpadding="2.5px" rules="all" style=";background-color: rgb(255,255,255);border: 1px solid;border-collapse: collapse; border-color: rgb(102,0,0)"><colgroup><col...
  9. Re: Return header value from a column of data in another worksheet

    Team, Is this OP looking for ?

    <b>Excel 2013/2016</b><table cellpadding="2.5px" rules="all" style=";background-color: rgb(255,255,255);border: 1px solid;border-collapse: collapse; border-color:...
  10. Replies
    10
    Views
    371

    Re: sumproduct or countA, but how :)

    I guess, "eating an Apple before going to bed and you"ll keep away the doctor from eating his bread"
  11. Re: Return multiple lookup results in different cells

    I got you. Thanks Peter.

    @ Kacker17, Thanks
  12. Thread: #N/A Values

    by Sam_D_Ben
    Replies
    9
    Views
    213

    Re: #N/A Values

    Hi Fluff, Hi Rick,

    How you been. A quick question. How about considering "Sort option" as the easiest way to get the desired result. :)
  13. Replies
    8
    Views
    500

    Re: Need help with countif

    Peter_SSs, Yes, Yes, thats what OP wants. My brain dint work in that way. Thank you :)
  14. Replies
    8
    Views
    500

    Re: Need help with countif

    Or,

    <b>Excel 2013/2016</b><table cellpadding="2.5px" rules="all" style=";background-color: rgb(255,255,255);border: 1px solid;border-collapse: collapse; border-color: rgb(102,0,0)"><colgroup><col...
  15. Replies
    8
    Views
    500

    Re: Need help with countif

    Error.
  16. Replies
    8
    Views
    500

    Re: Need help with countif

    Something like this.

    <b>Excel 2013/2016</b><table cellpadding="2.5px" rules="all" style=";background-color: rgb(255,255,255);border: 1px solid;border-collapse: collapse; border-color:...
  17. Replies
    8
    Views
    500

    Re: Need help with countif

    You mean something like PIVOT.

    https://i.imgur.com/p9oPrUp.jpg
  18. Replies
    5
    Views
    340

    Re: Countif Formula

    Thats ok, The reason i asked you about countif and stuff, cause looking at your data, seems you can easily achieve the result using "Pivot". I guess you don't need to create any extra table or any...
  19. Replies
    5
    Views
    340

    Re: Countif Formula

    <b>Excel 2013/2016</b><table cellpadding="2.5px" rules="all" style=";background-color: rgb(255,255,255);border: 1px solid;border-collapse: collapse; border-color: rgb(102,0,0)"><colgroup><col...
  20. Re: EDate a VLookup when VLookup comes up blank

    EDATE(A1,B1), This is something new to me.
  21. Re: Help with matching by alpha and by number

    Peter - Is this MaGIC ? :)
  22. Re: Return multiple lookup results in different cells

    Hi Peter,

    Thank you for pointing out that, I applied it and found effective.


    {=IFERROR(INDEX($B$2:$B$18,SMALL(IF($D5=$A$2:$A$18,ROW($A$2:$A$18)- (ROW($A$2))+1,""),COLUMN()-4)), "")}
  23. Re: Return multiple lookup results in different cells

    Something like this.

    <b>Excel 2013/2016</b><table cellpadding="2.5px" rules="all" style=";background-color: rgb(255,255,255);border: 1px solid;border-collapse: collapse; border-color:...
  24. Replies
    1
    Views
    119

    Re: sum data of two table in two sheets

    After summing up, i guess trying "AVANCED FILTER" option help you find the unique records with in the range or to copy to a different location with in the sheet.
  25. Replies
    11
    Views
    359

    Re: count values between dates

    I know that Dan. :)
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4