PC Review


Reply
Thread Tools Rate Thread

Aggregate Data from a column in a cell

 
 
=?Utf-8?B?RW5yb24=?=
Guest
Posts: n/a
 
      20th Feb 2006
Hi,

I've a table in a spreadsheet giving some bottom line figures for each month
for several years. This table is based on other spreadsheets containing the
daily data.

Those spreadsheets with daily data also contain in one column, some text
input (comments on some of the daily data).

How could I select from my first table (bottom lines for each month) to see
the daily comments if they exist for that month ?

Up to now, I've put a column next to my monthly bottom line showing how many
daily comments are available using :
=COUNTA(INDIRECT(CONCATENATE(Sheet Name(from a drop down box),"!",Range)))
(I put in manually the range of the days for each month)
So, I'm not arrived yet ... :-(

Thanks a lot for trying to understand this messy question and any answer
proposal ...

Cheers

 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
add data in column related to cell in another column - see full de Migty Microsoft Excel Worksheet Functions 1 11th Sep 2009 03:35 AM
Copy last cell with data in column E on one sheet to cell on anoth Seahawk Microsoft Excel Worksheet Functions 7 7th May 2009 02:52 AM
Aggregate column uses defaultview? benji Microsoft ADO .NET 3 19th Dec 2007 06:13 PM
code to go down a column and find the last cell with data before an empty cell Steve G Microsoft Excel Programming 1 23rd Jul 2007 08:22 AM
To have a 'fixed cell' be equal to the last data entered cell in a column Mathew P Bennett Microsoft Excel Misc 2 22nd Aug 2003 06:09 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 02:55 AM.