ST Alpha - "maybe this is easier than i think it is, but I am lost this morning, excel question" (Reading a Post)

SlickerTalk
Search Archives
The Leaderboard
The FAQ

Down to Post

Backboards:

Posts: 163

maybe this is easier than i think it is, but I am lost this morning, excel question

Posted by tRuMaN (aka Truman) Oct 19 '11, 07:58

i have to 4 columns, which are two sets of a description (like 11000 - Cash:11002) and amount.

how do I combine these so that I can get only 1 column of descriptions with both matching amounts?

Responses:

=A1&" "A2 joins a1 and a2 with a space between. (who can type concatenate correctly??) -- nm - amanda jones Oct 19, 08:01 4
- I know I'm playing COCKENATE the next chance I get. -- nm - Max Oct 19, 08:03 3
  - right?? -- nm - amanda jones Oct 19, 08:03 2
    - speaking of "??", patryk says it's poor form to use "??," that "???" is the accepted version. I *always* use "??" - amanda jones Oct 19, 08:04 1
      - the answer is patryk is always full of crap. -- nm - Max Oct 19, 08:05
CONCATENATE function? -- nm - Bloger Blore Oct 19, 08:00 4
- arg, no, concante isnt what I want. I dont want to merge the fields, I want to create a page showing - tRuMaN Oct 19, 08:02 3
  - I think it is what you want, actually. You want Content1+ Content2, right? -- nm - loosilu Oct 19, 08:03 1
    - he might be looking to pivot description in rows and amount one and amount 2 in columns. he's not saying what he wants. -- nm - amanda jones Oct 19, 08:06
  - can't you do a subtotal by description? you're looking for a summary? -- nm - amanda jones Oct 19, 08:03
CONCATENATE? joins 2 text fields into 1 field -- nm - Strongbad Oct 19, 08:00 11
- ok, so here is the kicker (which I should have added) what happens when group 2 doesnt have the matching description? - tRuMaN Oct 19, 08:00 10
  - I just tested this - it just repeates what is in group 1 -- nm - Bloger Blore Oct 19, 08:03
  - so wwhat do you want to display if the decsription is empty? -- nm - amanda jones Oct 19, 08:02 4
    - let me give an example. - tRuMaN Oct 19, 08:06 1
      - so like this? - amanda jones Oct 19, 08:08
    - "HELP" -- nm - Max Oct 19, 08:03 1
      - =if(a1>0, A1&" "A2, "HELP") -- nm - amanda jones Oct 19, 08:05
  - are the rows themselves lined up properly? -- nm - loosilu Oct 19, 08:02 3
    - those words make no sense. - tRuMaN Oct 19, 08:03 2
      - where does the description come in? -- nm - loosilu Oct 19, 08:05 1
        
        "what are you trying to do?" right?? -- nm - amanda jones Oct 19, 08:06

Post a message top

maybe this is easier than i think it is, but I am lost this morning, excel question

Replies are disabled on threads older than 7 days.