+ Reply to Thread
Results 1 to 2 of 2

"Multiply" xyz by values

Hybrid View

  1. #1
    Registered User
    Join Date
    12-04-2014
    Location
    Estonia
    MS-Off Ver
    2014
    Posts
    1

    "Multiply" xyz by values

    Untitled.jpg
    xyz have values 1,5,3 and result must be that whatever the value, this is the count they have to appear in the next column. Can somebody help me with that?

    PS! in my data xyz will be representing bear sighting coordinates
    And values represent how many bears were sighted

  2. #2
    Forum Expert
    Join Date
    07-20-2011
    Location
    Mysore, India.
    MS-Off Ver
    Excel 2019
    Posts
    8,710

    Re: "Multiply" xyz by values

    I,n C2,then drag down.
    =IFERROR(INDEX($B$2:$B$4,SMALL(IF(SUM(COUNTIF($C$1:$C1,$B$2:$B$4))<SUMIF(OFFSET($A$2,0,0,ROW($1:$3)),">0"),ROW($1:$3),""),1)),"")
    ARRAY formula is used

    To enter ARRAY formula
    Paste the formula
    Press F2
    Press Ctrl+Shift+Enter keys together.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Formula needed to display "Pass" or "Fail" if a column contains any values other than "yes
    By andreindy in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 03-26-2013, 05:49 PM
  2. Replies: 0
    Last Post: 01-09-2013, 06:52 PM
  3. Replies: 3
    Last Post: 02-16-2011, 02:55 PM
  4. 3 "w" cells,multiply the values next to them
    By jonfouk in forum Excel General
    Replies: 1
    Last Post: 04-09-2008, 01:13 PM
  5. Changing "returned" values from "0" to "blank"
    By LATATC in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-20-2005, 12:05 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1