list numbers in a block of cells

Is there a way to list the values in a block of cells.

      400 600 800
      350 200 625
      250 222 125
      9958 226 123


Like:

400
600
800
350
200
625
250
222
125
9958
226
123 


0
Jeff
12/14/2007 10:33:02 PM
excel 39879 articles. 2 followers. Follow

2 Replies
504 Views

Similar Articles

[PageSpeed] 28

Assume source data in A1:C4

Put in say, E1:
=OFFSET($A$1,INT((ROWS($1:1)-1)/3),MOD(ROWS($1:1)-1,3))
Copy E1 down to E12
-- 
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
--- 
"Jeff Klein" <jklein@nospam> wrote in message 
news:%23PyCLFqPIHA.5140@TK2MSFTNGP05.phx.gbl...
> Is there a way to list the values in a block of cells.
>
>      400 600 800
>      350 200 625
>      250 222 125
>      9958 226 123
>
>
> Like:
>
> 400
> 600
> 800
> 350
> 200
> 625
> 250
> 222
> 125
> 9958
> 226
> 123
> 


0
demechanik (4694)
12/15/2007 3:32:30 AM
Or use Reverse Pivot Table.
No formulas or code required. See
John Walkenbach's site:
http://preview.tinyurl.com/2xykg6
0
12/15/2007 4:13:42 PM
Reply:

Similar Artilces:

Customizing Activities\History LIst
Is there a way to add a date to Activities' History list? It would be nice to know when each activity happened. Thanks, Troy Troy, no way currently, although Microsoft has mentioned it might be an option in version 2.0 (nothing is guaranteed!) A few ISVs have custom products that do it... www.salentica.com www.c360.com Dave "Troy" <anonymous@discussions.microsoft.com> wrote in message news:af6b01c436bd$ce671f00$a001280a@phx.gbl... > Is there a way to add a date to Activities' History > list? It would be nice to know when each activity > happened. >...

Using TEXT and &TEXT
I'm familiar with the TEXT function, but sometimes a number will display incorrectly when I format numbers to display with a comma if 4 digits or more. For example, TEXT(F1,"0,0") will display 10 thru 999 correctly and displays 1000 correctly as 1,000, but displays 1 thru 9 as 01, 02, etc. Also wondering how to format part of a TEXT formula to underline, and bold or color selected words. Maybe you want: =text(f1,"#,###") or =text(f1,"#,##0") If this doesn't help, maybe you could post the values and what you want to see for a few exa...

splitting a single cell
Is it possible to split a single cell in Excel 2003? See your other post. "BK" <nospam@nospam.com> wrote in message news:%23QLbGI6oKHA.5696@TK2MSFTNGP04.phx.gbl... > Is it possible to split a single cell in Excel 2003? > ...

Better to "nest" or use multi-level list?
I'm in the process of creating/defining a style(s) for a list that will be numbered in "level 1" and have indented bullets in "level 2." For such a list is it better to define a multi-level list style and linked paragraph styles? Or use one's already defined numbered list and use one of the Word's pre-defined bullet lists when needed for the second level? As part of this question, is is preferable not to have a style "nested" within another style or doesn't it matter? Thank you. -- Norm Hi Norm: I'm not sure why yo...

how to prevent blank cell copied when combining cells?
I've tried to combine data from few cells using "CONCATENATE" function. But, when a cell is blank, a blank appears in the result. How to prevent this blank? please give sample to understand better "Vicneswari Murugan" wrote: > I've tried to combine data from few cells using "CONCATENATE" function. But, > when a cell is blank, a blank appears in the result. How to prevent this > blank? =if(a1="","",a1&" ")&if(b1="","",b1&" ")&c1 It kind of sounds like you were separ...

Distribution List Changes
Hi All, I have a mail enabled distribution list with four users. Only those users plus the Administrator have rights on this group. Yet a seperate user is able to add / edit or remove users to this group even though they do not belong to this group. The user does not even have admin rights and is able to make changes. Let me know of any options I can try. Thanks Waynear wrote: > Hi All, > > I have a mail enabled distribution list with four users. Only those > users plus the Administrator have rights on this group. > > Yet a seperate user is able to add / edit or remov...

Sound shows on custom Annimation list yet no sound heard
When the PP Presentation is saved as a show,some slides have sound and some do not. All sound came from the same folder. Also, when playing the slides while in PPPresentation, swome have sound and some do not despite all being indicated on custom annimation lisy and all startin "after previous." Thanks! Often when one sound plays but another doesn't, it's an issue of the length of the file path. What's the file path to your music? Is it really long? If so, the longer-named songs might just be hitting the length limit. -- Echo [MS PPT MVP] http://www.ec...

#VALUE! error adding cells
I am trying to add a row of numbers contained in every other cell. This worked fine and I was able to copy the formula from one cell to the other. On the final cell, instead of adding the numbers, I am getting the message #VALUE!. I cannot figure out how to correct this problem. Check to see if you have a text value in one of the referenced cells - either actual text or a number that looks like text "Frustrated computer user" wrote: > I am trying to add a row of numbers contained in every other cell. This > worked fine and I was able to copy the formula from one ce...

Drop Down List and Check Box
Hi...I was search for this topic but don`t found the solve...Anyway I have a drop down list like this [image: http://www.geocities.com/augurtrade/excel_checkbox.txt] and this [image: http://www.geocities.com/augurtrade/excel_checkbox2.txt] ok my questions is what is (Blanks) and (NonBlanks)...? Is it possible for me to see only all the check box that was checked or vice versa...??? How to make a total below the checkbox i mean when someone check the check box, a total number appear below the last check box [image: http://www.geocities.com/augurtrade/excel_checkbox3.txt] [image: http://www.g...

Continue Numbering #2
I'm wondering if the "Continue numbering" option is in Publisher as it is in Word? Example: I start creating a numbered list. After the second item, I need to insert a few bullets. I then want to go back to the numbered list. Word has a smart tag, asking if you want to continue numbering. Is there a similar feature in Publisher? Right now, I have to go to Format, Bullets & Numbering and change the start number every time this happens. ...

how reliable is the "Who has you in their contact list" list?
Because someone who I think has recently (within the last week) deleted me is still on this list (I don't think she blocked me), but when I check who deleted me on blockstatus.com, he shows up. could it be it's not updated? which of the two would be more reliable? -- maykk Greetings, Do not use these websites, they will steal your identity and sell it. You should change your password immediately. That said, in general, the "who has..." list within Messenger is accurate. There have been instances over the last six-months or so where the list (and m...

Split text and number
Cell A1 = New England 30, Oakland 20. Is it possible to have the following: cell B1 = New England cell C1 = 30 cell D1 = Oakland cell E1 = 20 Cells A2-A16 are similar but the team name and number changes and the team names are all different lengths. If that won't work I could use text to columns and split it at the , so cell A1 = New England 30 and cell B1 = Oakland 20. But I would still want the team name and score to be separated. Using the above method would save me from having to use the text to columns command. Thanks If you use the text to column, you could then use =r...

Selecting from contacts list
I have all my contacts in the Contacts List and I want to delete all those with a common extension i.e. all those who have email addresses @hotmail. I am using Outlook 2007 Can you do a search or advanced search which will show the contact you want to delete? You should be able to highlight & delete them from the results. "GrahamC" <GrahamC@discussions.microsoft.com> wrote in message news:6AC1880D-9632-4ED9-BAE2-7083690B9FA7@microsoft.com... > I have all my contacts in the Contacts List and I want to delete all those > with a common extension i.e. all t...

How to line up the last cell in each row?
I have some data for which I am only interested in the final column from each row. The problem is that each row is a different length, so that row 1 may be 10 columns wide, row 2 15 columns, etc. How can I get the last element from each row to line up in the same column so that I can sort, sum, etc.? Here is one solution: Insert a new column at A1 so you now have shifted all of your data to the right. Assuming that Row 1 has headers your first data record will be in row 2. Type this formula into A2 =OFFSET(B2:IV2,0,COUNTA(B2:IV2)-1,1,1) Drag copy down to the end of your data. Column ...

Script to list access right
Hi I am trying to find any script which would generate list of login users with certain access level (select, write etc.) at one particular database. Is there something like that? Thanks. Justin ...

macro to check if cells have values in them...then
Hi - I am looking for a macro that will check 2 things....then do something. The first is if a range of cell values in are blank. lets say Sheets("Sheet1").Range("D6:G48"). Next is if a particular cell contains a given value , Sheets("sheet1").Range("E5") should equal "Year 1" if true. If both these are true then I want the macro to copy a range of cells from Sheets("Sheet2").Range("H6:H48") to Sheets("Sheet1").Range("D6:D48"). I tried to use IsEmpty but it seems to return a "False" if a...

Truncating and rounding off numbers in VBA
Two simple questions that hopefully have simple solutions to them. 1) I want to truncate a number (34.6) so the end result only shows 34. I cannot find the function in VBA and its help service is of no help? IS there one and if so what is it? 2) Also, is there a function for rounding off as well. I tried to set the decmals property for an unbound textbox control to 1 but it has no effect on the result numbers that come out (eg. 24.3245 instead of 24.3). Why is that and how can I solve this? I was thinking I could use a roundoff function in VBA but can't find what it is or if it e...

week numbers
Hi, In MS CRM you have week numbers which aren't equal to the ones we use in the Netherlands. CRM says that 1 januari is week 1, but that isn't correct for us. For us is the first week of the year where we have 4 days in januari. How could I change this? Microsoft Outlook does it correct. thanks in advance, Hi, We had the same problem and found the following solution! Make a backup of the [CRM-Directory]\_controls\datetime\date.js in and then open it and replace the getWeekNumber function with the following code: function getWeekNumber( oDate ) { var oSiebterJanuar = new...

a list of lists
currently i use CArray to keep track of a list of objects, but I don't know MFC classes well enough to keep track of a list of lists. I'd appreciate some suggestions "wanwan" <ericwan78@yahoo.com> ha scritto nel messaggio news:1187535523.924671.143350@j4g2000prf.googlegroups.com... > currently i use CArray to keep track of a list of objects, but I don't > know MFC classes well enough to keep track of a list of lists. I'd > appreciate some suggestions You might want to embedd your list based on CArray into a class (e.g. CListOfSomething), and then ...

Smart List export to Excel #2
Hi, We are using Dynamics 9.0 and Office 2003. When we try to do a Smart List export to Excel, we keep getting an "Exception_Class_Object_Exception" that references varying object errors, such as 'Cells' or 'Value'; the object errors will change each time we try an export. As a workaround, I've found that closing Excel before doing the export allows the export to complete successfully. However, that solution isn't acceptable, as our Dynamics users would like to be able to work in Excel, doing other tasks, while the export is processing. Does anyone...

List of different values in data area
Hi excel specialists, How Can I automatically get the list of different values from the dat area and to find out their frequence? INDIVIDUALLY MEASURED VALUES: 3,5 4 3,5 4 3 3,5 4 4 3 3,5 4 3 3,5 3 3 3,5 4 4 Thanks for your help in advance. Balcovja -- balcovj ----------------------------------------------------------------------- balcovja's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=2623 View this thread: http://www.excelforum.com/showthread.php?threadid=39572 Take a look at FREQUENCY in Hep -- HTH RP (remove nothere from the email address if m...

Text block query
I wish to create a block of several lines of text inside a border on a worksheet. What terms do I look for to describe this operation? Just wasted an hour looking in vain. I know I will kick myself when someone points me in the right direction. Thanks Brian Tozer Brian Tozer wrote: > I wish to create a block of several lines of text inside a border on a > worksheet. > What terms do I look for to describe this operation? > Just wasted an hour looking in vain. > I know I will kick myself when someone points me in the right > direction. Cancel panic. Problem solved. As usua...

range specified by the value in another cell
I have the following problem: I have let say 100 numbers in column A, and a number n<100 in cell B1. I want to have the sum of the first n numbers in column A, so I would need to specifiy the range A1:An, but I need this independently of the actual value of n. I have tried A1:A(B1) with but it doesn't work. So has somebody any idea -- Message posted from http://www.ExcelForum.com Hi 2 ways for it 1. Use the formula =SUM(INDIRECT("A1:A"&B1)) 2. Create a named range RangeToSum=OFFSET(SheetName$A$1,,,SheetName!$B$1,1) The formula will be =SUM(RangeToSum) -- (When s...

Global Address List and Handhelds
We use Ipaqs throughout the company, and I was wondering if there is anyway to have exchange add the GAL to the outlook contacts on the workstation, so that when they sync up, they will retrieve the Global Address List? In news:%23TkYtT0$GHA.3560@TK2MSFTNGP04.phx.gbl, Flip <phil.atkinson@beltek.com> typed: > We use Ipaqs throughout the company, and I was wondering if there is > anyway to have exchange add the GAL to the outlook contacts on the > workstation, so that when they sync up, they will retrieve the Global > Address List? No (and this wouldn't really be an ...

Removing Page Number from Final Page- Publisher 2002
Dear Mary Sauer: I used the header function to page number my newsletter. I got rid of the page number from the first page. How do I eliminate it from the back (last) page. Iused the text box tip to do the former. Thanks Barry Create a rectangle, fill with white, no line. Cover the page number. -- Mary Sauer MSFT MVP http://office.microsoft.com/ http://msauer.mvps.org/ news://msnews.microsoft.com http://officebeta.iponet.net/en-us/publisher/FX100649111033.aspx "Barry" <cbj97@yahoo.com> wrote in message news:uJ2EE$R3GHA.1608@TK2MSFTNGP04.phx.gbl... > Dear Mary Sauer:...