Close

Results 1 to 5 of 5
  1. #1
    DF Super Moderator
    DejaVu's Avatar
    Join Date
    Nov 2005
    Location
    Essex
    Posts
    9,107
    Thanks
    1,836
    Thanked:        4,004
    Karma Level
    953

    Default A little Excel assistance please.

    I'm using Appsheet.com to create my own Android App and it utilises Excel/Google Sheets for charts and information.

    I'm trying to create a formula for a certain scenario. I'll try and explain it as best I can.

    In Column A I've got addresses.
    In Column G I've got the Date.
    Column K has an amount in monetary value.

    I'd like to consolidate all the addresses within that month into a new cell separated by commas - or better still, by a new line within the same cell. Make sense?
    I've managed to sort out adding the amounts into one cell via month using something like this which works out the amount for the month of May 2017.
    Code:
    =SUMIFS(K:K,G:G,">="&DATE(2017,5,1),G:G,"<"&DATE(2017,6,1))
    What would I need to use to do this?
    I'm guessing IFS and TEXT along with CONCENTATE perhaps, but after trying to work it out for the day and plenty of googling, I'm getting nowhere.

    I reckon it's probably pretty straight forward, but I cannot bend my head around it - or is there an easier way for either that I've missed without the need for the serious programming side of things?




  2. #2
    DF VIP Member akimba's Avatar
    Join Date
    Jun 2006
    Location
    UK
    Posts
    2,846
    Thanks
    1,034
    Thanked:        783
    Karma Level
    369

    Default Re: A little Excel assistance please.

    Have you looked at SUMPRODUCT for the totals.

    I still not sure what you mean with the addresses?

  3. #3
    DF Super Moderator
    DejaVu's Avatar
    Join Date
    Nov 2005
    Location
    Essex
    Posts
    9,107
    Thanks
    1,836
    Thanked:        4,004
    Karma Level
    953

    Default Re: A little Excel assistance please.

    Quote Originally Posted by akimba View Post
    Have you looked at SUMPRODUCT for the totals.

    I still not sure what you mean with the addresses?
    Addresses are customers address.

    If something is equal to yes during each month, list those addresses separated by commas by month in a single cell.

    Sent from my SM-G935F using Tapatalk


  4. #4
    DF VIP Member flipper321's Avatar
    Join Date
    Feb 2003
    Location
    Essex
    Posts
    2,696
    Thanks
    11
    Thanked:        131
    Karma Level
    474

    Default Re: A little Excel assistance please.

    This isn't possible in a single cell without writing a UDF (user defined function).

    The other option is to add an additional column to do the concatenation and a lookup to find the last entry.

  5. #5
    DF Super Moderator
    DejaVu's Avatar
    Join Date
    Nov 2005
    Location
    Essex
    Posts
    9,107
    Thanks
    1,836
    Thanked:        4,004
    Karma Level
    953

    Default Re: A little Excel assistance please.

    Using further fields/worksheets to grab the data is not a problem if required.

    Only reason I don't think UDFs are not for me is I have no idea about them and likely to boil my box!

    Sent from my SM-G935F using Tapatalk


Similar Threads

  1. [HELP] Your assistance please
    By CallmeGoose in forum Talk About Photography
    Replies: 69
    Last Post: 27th January 2014, 04:47 PM
  2. [HELP] New to Sky+ HD and need assistance.
    By DejaVu in forum Digital Satellite TV
    Replies: 3
    Last Post: 2nd February 2011, 03:22 PM
  3. FPS Assistance / Overkill?
    By Chubbs in forum Microsoft Consoles
    Replies: 0
    Last Post: 21st November 2010, 10:50 AM
  4. [HELP] a little assistance
    By strife in forum The Dog and Duck
    Replies: 3
    Last Post: 24th June 2010, 08:29 PM
  5. Assistance required if possible
    By 889dnp in forum Radio Decoding
    Replies: 6
    Last Post: 7th October 2004, 02:49 PM

Social Networking 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
  •