Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old December 18th 12, 05:45 AM
Junior Member
 
First recorded activity by ExcelBanter: Dec 2012
Posts: 29
Default List with Duplicates to uniques list

Hi,

I have a large list of account codes in column C, i.e:
410500
410500

410500
443000
443700
etc

What I'd like to do is next to it in column D have that same list, but without the duplicates or empty cells, (i.e. from small list above = 410500, 443000, 443700).

What formula might achieve this?
Thanks in advance.

  #2   Report Post  
Old December 18th 12, 07:50 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Dec 2012
Posts: 49
Default Drop Down List Dependant Formula

I have a drop down list where a user can select the month (cell I6).
I also have a data set on another sheet like this:

jul;aug;sep;oct;nov...Total;YTD Total
100;250;350;420;530...Total;YTD Total

Assume date range starts in A1 and figures start in A2. Also, the fiscal
year starts in July, not January.

What I'd like to have happen is that depending on the month selected
from the list - for that selection to drive a YTD sum
calculation/function, i.e. If the user selects October from dropdown
list - then the YTD total sum will only include months upto and
including October only (i.e. July, Aug, Sep, Oct).


Try this for the YTD total:
=SUM(OFFSET($A$2,0,0,1,MATCH(I6,A1:L1,0)))
This assumes that the same month name spellings are used in I6 and A1:L1.

Modify as needed.


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Condensing a list with duplicates to a list with non-duplicates Nuclear Excel Worksheet Functions 2 July 29th 08 08:03 PM
Array Formulas - Unique List from List with Duplicates Johnny Meredith Excel Discussion (Misc queries) 7 October 27th 06 09:26 PM
Count Uniques within a list based on value of cell... MeatLightning Excel Discussion (Misc queries) 3 March 20th 06 05:21 PM
How to remove duplicates from a list and copy new list to new colu Chance Excel Worksheet Functions 2 April 23rd 05 05:21 AM
Compare & create list of uniques across books/sheets P.Rumpz Excel Programming 1 April 2nd 04 10:10 PM


All times are GMT +1. The time now is 10:48 AM.

Powered by vBulletin® Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright 2004-2020 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017