software

Hi everyone,

Here's another challenge:

On a worksheet, I have a column of consecutive recurring data (meaning
this column is sorted). How do I return the range of a particular
recurring data?--
ledzepe
------------------------------------------------------------------------
ledzepe's Profile: www.excelforum.com/member.php...oamp;userid=25207
View this thread: www.excelforum.com/showthread...hreadid=513736Can you provide an example of your data, showing the state it's in now
and the state you'd like it to be in? For instance, when you say
quot;return a particular range of dataquot; do you mean data that is between
two values?
The data is like below:

Acct, Qty, Desc, Wt., Rate, Cost
R123, 2, skids, 40, 11%, 10.00
R123, 0, FCS, 0, 15%, 3.00
R321, 1, skid, 100, 11.2%, 21.00
R321, 2, rolls, 100, 11.2%, 21.00
R321, 0, FCS, 0, 15%, 5.00
R654, and so on...

My recurring data is the first column, quot;R321quot; and then I want to
extract the Cost of each line that has R321. There is probably two
thousand lines and 500 accounts in each spreadsheet. My boss wants a
report that would get the cost of any given set of accounts that he
specify.--
ledzepe
------------------------------------------------------------------------
ledzepe's Profile: www.excelforum.com/member.php...oamp;userid=25207
View this thread: www.excelforum.com/showthread...hreadid=513736
this a continuation of the last post...

The format that my boss wants is below (taking the account R321):

Acct, Qty, Wt., FSC, Cost
R321, 3, 200, 5, 42.00

I can do a VLOOKUP on the first R321 line but I can't get the second or
the third R321 line. I was thinking if there is a formula that would
output the range of R321, I can do a LOOKUP on that range.--
ledzepe
------------------------------------------------------------------------
ledzepe's Profile: www.excelforum.com/member.php...oamp;userid=25207
View this thread: www.excelforum.com/showthread...hreadid=513736Maybe applying data|filter|autofilter would be a way to show/hide the data you
need.

Or maybe doing data|subtotals would be ok???

ledzepe wrote:
gt;
gt; The data is like below:
gt;
gt; Acct, Qty, Desc, Wt., Rate, Cost
gt; R123, 2, skids, 40, 11%, 10.00
gt; R123, 0, FCS, 0, 15%, 3.00
gt; R321, 1, skid, 100, 11.2%, 21.00
gt; R321, 2, rolls, 100, 11.2%, 21.00
gt; R321, 0, FCS, 0, 15%, 5.00
gt; R654, and so on...
gt;
gt; My recurring data is the first column, quot;R321quot; and then I want to
gt; extract the Cost of each line that has R321. There is probably two
gt; thousand lines and 500 accounts in each spreadsheet. My boss wants a
gt; report that would get the cost of any given set of accounts that he
gt; specify.
gt;
gt; --
gt; ledzepe
gt; ------------------------------------------------------------------------
gt; ledzepe's Profile: www.excelforum.com/member.php...oamp;userid=25207
gt; View this thread: www.excelforum.com/showthread...hreadid=513736

--

Dave Peterson


Autofilter is how I'm doing right now.

If I do a sub-total, is there a way name the range of the result?--
ledzepe
------------------------------------------------------------------------
ledzepe's Profile: www.excelforum.com/member.php...oamp;userid=25207
View this thread: www.excelforum.com/showthread...hreadid=513736The results of a subtotal is that the worksheet has subtotals.

I was suggesting that you use subtotals and the outlining symbols to the left to
show what you want.

ledzepe wrote:
gt;
gt; Autofilter is how I'm doing right now.
gt;
gt; If I do a sub-total, is there a way name the range of the result?
gt;
gt; --
gt; ledzepe
gt; ------------------------------------------------------------------------
gt; ledzepe's Profile: www.excelforum.com/member.php...oamp;userid=25207
gt; View this thread: www.excelforum.com/showthread...hreadid=513736

--

Dave Peterson


Thanks for the ideas but since the data is in .CSV I made a script to
extract it then re-export the data to a .CSV.--
ledzepe
------------------------------------------------------------------------
ledzepe's Profile: www.excelforum.com/member.php...oamp;userid=25207
View this thread: www.excelforum.com/showthread...hreadid=513736