Windows Support Forum

Solved: Excel-adding columns

Q: Solved: Excel-adding columns

Adding rows 5 thru 10 on line 11 I use function, and get a total for column A. When I go to column B I have to type in function again - and also in C-D etc. Is there a way to get all the desired columns added on line 11? I use XP home with Excel.

Relevancy 100%
Preferred Solution: Solved: Excel-adding columns

I recommend downloading and running Reimage. It's a computer repair tool that has been proven to identify and fix many Windows problems with a high level of success.

I've used it in the past to identify and fix everything from blue screens (BSOD's), ActiveX errors, corrupt files and processes, dll/exe/sys errors, recover lost memory, Windows update problems, defragging, malware removal etc.

You can download it direct from this link http://downloadreimage.com/directdownload.php. (This link will automatically start a download of Reimage that you can save to your computer.)

A: Solved: Excel-adding columns

Just click on the bottom right of the total in Column A.
You should see a set of crosshairs.
Drag it through the other cells that you wish totalled,

https://forums.techguy.org/threads/solved-excel-adding-columns.537292/
Relevancy 92.45%

Help please.

I've done a excel spreadsheet, where across the sheet in a line with maybe a few letters 'x' or 'H' or 'BH' and the next line will have the same. This could be from line 8 to line 121.

But in a column say 'T8' to 'T121' I want to count the total number of 'x's in that column, also 'H' and 'BH' giving the total individually. ie:- x=3 H=6 BH=4 for column 'T' and the same with the other columns.

Can this be done, please.
 

A:Solved: Help required with Excel adding letters in columns

you could do a count in seperate columns

so
in A1
put
=COUNTIF(T8:T121, "X")
in A2
=COUNTIF(T8:T121, "H")
in a3
=COUNTIF(T8:T121, "BH")
 

https://forums.techguy.org/threads/solved-help-required-with-excel-adding-letters-in-columns.403964/
Relevancy 77.83%

Ok I am trying to print a spreadsheet format list. I have about 30000
title-artist entries in 2 columns. I am basically trying to print pages 1 & 2, 3-4, 5-6 and so on the same page without shrinking them way down. I want it to be just like I printed 2 columns but with 4 instead. I want to use the left side of the page for page 1 and the left side for page 2. Any help would be greatly appreciated.

Michael
 

A:Solved: Printing 4 Columns from 2 columns in excel

Welcome to the board.

http://www.asap-utilities.com/asap-utilities-excel-tools-tip.php?tip=124&utilities=Format ?
 

https://forums.techguy.org/threads/solved-printing-4-columns-from-2-columns-in-excel.773525/
Relevancy 73.1%

Good morning I have the code below which includes comments quot Sub AIRLog AIRLog Macro Names the worksheet quot AIRLog quot Sheets Name quot AIRLog quot Insert new column at Column O This is to concatenate Columns L-N for the quot Actions Impacts Resolution quot column Columns Select Selection Insert Shift xlLeft Range quot O quot Value quot Impact Action Resolution quot Removes the Table Style previously set by exporting AIRLog from SharePoint Columns using to a Solved: table VBA Adding ActiveSheet ListObjects quot Table AIRLog quot TableStyle quot quot Formats the table to Solved: Adding Columns to a table using VBA create customized Table Style Rows quot quot Select Selection Insert Shift xlDown Selection Insert Shift xlDown Selection Insert Solved: Adding Columns to a table using VBA Shift xlDown Range quot A T quot Select With Selection HorizontalAlignment xlCenter VerticalAlignment xlBottom WrapText False Orientation AddIndent False IndentLevel ShrinkToFit False ReadingOrder xlContext MergeCells False End With Selection Merge Selection Font Bold True With Selection Font Name quot Arial quot Size Strikethrough False Superscript False Subscript False OutlineFont False Shadow False Underline xlUnderlineStyleNone ThemeColor xlThemeColorLight TintAndShade ThemeFont xlThemeFontNone End With ActiveCell FormulaR C quot Actions - Issues - Risks Log quot Range quot Table AIRLog Headers ID quot Select Changes all the column widths including newly inserted column This will help create print area Columns quot A A quot ColumnWidth Columns quot B B quot ColumnWidth Columns quot C C quot ColumnWidth Columns quot D quot ColumnWidth Columns quot E H quot ColumnWidth Columns quot I I quot ColumnWidth Columns quot J K quot ColumnWidth Columns quot L N quot ColumnWidth Columns quot O O quot ColumnWidth Columns quot P quot ColumnWidth Columns quot Q Q quot ColumnWidth Columns quot R R quot ColumnWidth Columns quot S S quot ColumnWidth Columns quot T T quot ColumnWidth Columns quot U V quot ColumnWidth End Sub quot A little background information I have an extract that is already in Excel All I must do is change the sheet around a little bit to so that I set the print area There are two parts of my code where I add rows and then columns I need to add three rows at the top which works However when I want to insert ONE column to the left of column which is column O the resulting macro adds columns to the Left of column A What I am trying to do is add a single column to the left of column O so that all columns to the right of O are shifted over When I wrote the macro I used comments to divide each individual task When I divided them separately they all worked individually It seems like when I consolidate it in to one large macro this is happening Any help would be really appreciate Thanks tennisfrk nbsp

A:Solved: Adding Columns to a table using VBA

It may be that when the macro starts, more than one column is already selected. What happens if you put Range("A1").select at the beginning?
 

https://forums.techguy.org/threads/solved-adding-columns-to-a-table-using-vba.1061861/
Relevancy 67.08%

I decided to hide the first couple of columns in the spreadsheet. But for some reason I can't get them back. I tried selecting the first visible column, the whole spreadsheet, the View menu. Nothing. The columns won't unhide. And yes I need their data.

For the record, hiding and then unhiding works fine when it's not the first column.
 

Relevancy 67.08%

Hi,

I have a list of customer IDs in two columns. I want to generate the customer IDs which are missing in either of the two columns in a third column. What formula can be applied here?

Thanks in advance
 

Relevancy 67.08%

I have a spreadsheet that I wish to compare 2 columns and bring the information from the 3rd. For example, if A6 is equal to an item in G1:G98, then the number in B6 should equal the corresponding number in H1:h98. The formula I used is =VLOOKUP(A8,$G$1:$H$98,2,FALSE) It works great except the problem I have is sometimes there is no corresponding value in G1:G98. In that case I would like it to enter the number 0.
 

A:Solved: Excel comparing 2 columns

Hi Bsoda,

=IF(ISERROR(VLOOKUP(A8,$G$1:$H$98,2,FALSE)),0,(VLOOKUP(A8,$G$1:$H$98,2,FALSE)))
lol
Hew

(looking at what I just posted, its displaying an extra space in the final FALSE, but its not there when I go to Edit it!!)
 

https://forums.techguy.org/threads/solved-excel-comparing-2-columns.1003722/
Relevancy 67.08%

I'm using MS Excel 2007 under Win7 Prof.
In it, the columns visible in Excel are only upto 'IU', and all these columns are in use. Now, if I try to insert any more columns, the messages comes that "to prevent possible loss of data, Excel cannot shift Non-blank columns off the worksheet".
I'm stumped, and I need to increase the columns further and do not know how do I go about this.
Kindly Help.
Thanks in advance.
 

Relevancy 67.08%

I have been entering information into a template in Excel. The template was created by someone at work. This template has merged columns. I had no problem entering the information until I added two extra rows within the template. The added two rows are not merged but the merge function is grayed out and I am unable to select it. What could be the problem and how can I correct it?

Thanks,
Tonya
 

A:Solved: Trying to Merge Columns in Excel

can you post an example of the spreadsheet

if you highlight the two cells can you merge
 

https://forums.techguy.org/threads/solved-trying-to-merge-columns-in-excel.460167/
Relevancy 67.08%

Got a spreadsheet where the first column on the leftmost side is Column D.

I want to see Col A - Col C as I know they exist but I cannot see.
I move the cursor to A1 and am told the contents in top left corner of Excel.

Have tried Unhide the whole worksheet but no go.
 

Relevancy 66.65%

On the attached spreadsheet, I need a total count of baselined desktops (minus the ones that have been deleted)...my problem is how do I get it to look at one record, mark that that agent had been a baselined one, but is now deleted, so don't count it. I can't just remove the deleted ones, cause I want my customer to know which agents have disappeared. Take a look at the formula in B2 for a general idea. That formula doesn't work cause it just adds everything together. I need it to be smart enough to Total the Baselined Agents and then Subtract the agents that are baselined and deleted per field. Any questions let me know. Look at B2 to get an idea and see if I'm on the right track.
 

A:Solved: Excel - Trying to count 2 columns (almost as one) to get data for a 3rd.

https://forums.techguy.org/threads/solved-excel-trying-to-count-2-columns-almost-as-one-to-get-data-for-a-3rd.737946/
Relevancy 66.65%

All,

First, thank you all for you time and knowledge in advance.

Here's my situation. I'm working with file that is sent to me with populated information, in this example Col A
What I would like to do is enter information in Col B and then do a comparison of both A and B, letting me know if something in Col B is not in Col A and also is something in Col A not in Col B.

I need to know if what was sent to my in the spread sheet match what I physically inventoried.

I have provided an example.

Hopefully I did not over complicate my request.

Thank you,

miketx
 

A:Solved: comparing data in two columns in Excel

does this help
http://support.microsoft.com/kb/213367
http://office.microsoft.com/en-gb/excel-help/use-excel-to-compare-two-lists-of-data-HA001103915.aspx

or this may ble closer to what you need
http://forums.techguy.org/business-applications/174998-excel-compare-2-lists-highlight.html
 

https://forums.techguy.org/threads/solved-comparing-data-in-two-columns-in-excel.989078/
Relevancy 66.65%

I need to convert rows to columns in Excel like this:

Monday | 1
Tuesday | 2
Wednesday | 3
Thursday | 4
Friday | 5
Monday | 6
Tuesday | 7
Wednesday | 8
Thursday | 9
Friday | 0

to:

Monday | Tuesday | Wednesday | Thursday | Friday
1 | 2 | 3 | 4 | 5
6 | 7 | 8 | 9 | 0

Is this possible?

Well, that didn't display at all like I expected. In short, I need the repeating headers in column A to become one set of headers in row 1 with the data corresponding to each header name below it. Does that make sense?
 

A:Solved: Excel Rows to Columns with a Twist

Try this :

1) copy the days i.e(MondayTuesdayWednesday Thursday Friday Monday Tuesday Wednesday Thursday Friday
2) Go to the required cell and right click and select "paste special as" then select "Transpose"
You will get the data in this shape
MondayTuesdayWednesday Thursday Friday Monday Tuesday Wednesday Thursday Friday
4) Repeat the same step for other data............
 

https://forums.techguy.org/threads/solved-excel-rows-to-columns-with-a-twist.742146/
Relevancy 66.65%

I have data organised in paris of columns with differing amounts of data in each column pair.
I need to move all data to columns A&B:

- If there is data in columns C & D, move it to the foot of columns A&B.
- Then, if there is data in columns E & F, move it to the foot of columns A&B.
- Etc. til the end of the ActiveRange.

I've managed to do this using hard-coded column references, but it involves a lot of reptetition.
Presumably the code can be substantially compacted, and work to the end of the ActiveRange rather than to arbitrary end columns (in this case, cols AC and AD).
 

A:Solved: Excel VBA moving all data to columns A+B

Hi
This will work on the active sheet.... If you need this for multiple sheets we would need to alter the macro slightly. Test this on a copy of your xl file.

Code:

Sub appAB()

Dim i As Integer
Dim lRow As Integer
Dim lRowA As Integer

For i = 3 To 30 Step 2
lRow = Cells(Rows.Count, i).End(xlUp).Row
lRowA = Cells(Rows.Count, 1).End(xlUp).Row + 1
Range(Cells(1, i), Cells(lRow, i + 1)).Cut Destination:=Range("A" & lRowA)
Next

End Sub
 

https://forums.techguy.org/threads/solved-excel-vba-moving-all-data-to-columns-a-b.1128060/
Relevancy 66.65%

Hello. I am terrible with Excel and trying to learn how to use it. I created this chart with various functions but I cannot figure out how to get rid of tick type marks that go along 2 columns that I have. They appear in the upper left of each cell going down the column. Any help appreciated. Thanks
 

Relevancy 66.65%

Hi,

I have data in the following row format:

0 4591 5 4491 10 4461 15 4441 20 4321

The data are X and Z points so the above example shows 5 pairs of data. I would like to place these pairs of data sequentially in two columns where one column has all the X's and the other has the related Z's. I have many, many rows of similar data that I need transferred into two columns.

0 4591
5 4491
10 4461
15 4441
20 4321

Could anyone help me out with a macro that can do this for me?

Thanks very much in advance.
 

A:Solved: Excel Macro - Rows to Columns

Welcome to the board.

Let's say the example pairs are in A1:J1.

With A1:J1 selected,

Sub test()
For Each Cell In Selection
If Cell.Column Mod 2 = 1 Then
Range("A" & Rows.Count).End(xlUp).Offset(1) = Cell.Value
Else
Range("B" & Rows.Count).End(xlUp).Offset(1) = Cell.Value
End If
Next Cell
End Sub

gives you actual pairs in A2:B6.

So, what do we need to adjust to make it compatible with your "many, many rows of similar data" scenario?
 

https://forums.techguy.org/threads/solved-excel-macro-rows-to-columns.992309/
Relevancy 66.65%

I have a rather large file that I would like to print. I have other files like it that were done in Excel and they came out just like I wanted them to. The entries are arranged in rows and columns. I was able to number the rows and put headers over each column. The one in question is arranged in rows but not in columns. I can open it in Excel but I have no idea how to get it to arrange into columns. Is there any way Excel can do this for me? I'd really rather not do this manually because there are over three thousand rows that need to be in 12 columns.
 

Relevancy 66.65%

I am trting to create a chart using excel. I have inserted dates in column 1 - they are not sequential!. When I put the data into a chart it creates extra dates inbetween those I have actual placed in the cells. Help!
 

A:Solved: excel unwanted date columns

not a great solution - but format the dates as text - it should then only show the dates you have entered - and should be correct on the chart - but will be a number in the cells

not sure this is the correct way to go - but it seems to work

see attached
 

https://forums.techguy.org/threads/solved-excel-unwanted-date-columns.1042508/
Relevancy 66.65%

Hi - I m semi-proficient with excel and I m actually working on creating some dashboard reports at this time One problem I m having is separating some of the data from a specific column Let me give you an example This column has over lines in Excel columns? separation Data Solved: this is just a sample What I need to do is break this column out by month and show how many dates are from the last month the last - months and the Solved: Data separation in Excel columns? ones that are months in the past Of course I want the sheet to show this info automatically so it has to know the current date which I can do by placing the formula quot TODAY Solved: Data separation in Excel columns? quot So what I m asking for is what formula and format would I use to count how many cells in this column fall into each of date ranges I mentioned Also I did manage to use the DAYS A C for example where A quot Today quot and C quot quot above This information is in cells next to the above data as follows - - - - - - - - - - - - - - - - So I figured out how to list how many days I have since the date Solved: Data separation in Excel columns? in the first column but not how to break them apart within the column Hopefully this is enough information to request some help but if you need more info please let me know I ll watch the thread closely Thank you -Drake nbsp

Relevancy 66.65%

I am trying to write some vba code to Copy the the contents from each row in excel and make it into a new text file. I need the 1st Row to be in each text file though. So the 1st loop would be A1 & A2 row copy next loop would be A1 & A3 copy. When i paste the values in the new sheet to be saved as the text file I need to transpose the paste so row 1 now will be in column A. The filename would be created from the value in Column A. I have uploaded some example files. Any help would be greatly appreciated. The bonus would be if i could get any empty spaces removed from the cells.

I tried modifying some code that Jimmy the Hand wrote linked here
http://forums.techguy.org/business-applications/951580-save-excel-each-row-html.html
with no luck.
 

Relevancy 65.79%

I have several excel sheets which accumulate hidden in Solved: lists columns and Drop-down Excel data Solved: Drop-down lists and hidden columns in Excel at regular periods This accumulation involves the addition of new columns Each column contains one or two drop down lists When I report to other team members I send them pdf s of the datasheets In order to get the reports to fit on one piece of paper I hide the unnecessary columns When I hide the columns all the dropdown lists get shunted along to the first visible column This was never a problem until the format of the columns were changed request from the customer This change can not be implemented for all previous entries I now have the problem that the bunched up dropdown lists appear in the first visible column obscuring the title for that column How can I get around this problem without spending minutes temporarily deleting these dropdown columns each time I have thought about deleting them permanently except the sheet is also used by other people and this would cause unwanted problems I hope someone can help me Thankyou I should have added if Solved: Drop-down lists and hidden columns in Excel you hide columns C through F in the test file then you will see all the dropdown lists shift into column G nbsp

Relevancy 65.79%

Hi This is a fab site just spent a good few hours reading through without realising the time ANyway I am stuck on an Excel problem I have two columns of which there are lots of duplicates in column A and various values in column B Like this A B Book Title Song One Book Title Song Two Book Title Song THree Book Title Song One Book TItle Song Two Book Title Song Three Book TItle Song Four and so on for rows Merge two Solved: a Data Columns from row Sort Excel and into What I would like to do is have all of the relevant info from column B in just one cell in one row rather than a separate row for each song title So what I ideally need is A B Book Title One Song One Song Two Song Three Book Title Two Song One Song Two Song Three Song Four and so Solved: Excel Sort and Merge Data from two Columns into a row on Solved: Excel Sort and Merge Data from two Columns into a row I have no idea where to begin with this I have read several similar Solved: Excel Sort and Merge Data from two Columns into a row things that might help but the problem is that each Book Title has a different number of songs in it Can any one advise a complete beginner on how I might accomplish this Many thanks for any guidance nbsp

Relevancy 65.79%

I'm using some software to export payment information into a CSV file. This file needs to be in the bank's specified SIF format which requires all the data to be in one column.

The limitation with my software is that the detail of each payment gets exported into it's own separate column. For instance, cells A1:A10 contain payment details to one individual, B1:B10 to another, and so on. I require the whole lot combining into Column A, running from A1:A65536 (it will never go this far down the spreadsheet, but you get the idea).

I've tinkered with some basic copy and delete macros but I'm unable to make the headway that I need to. I don't have the touch when it comes to programming .

Thanks in advance
 

Relevancy 65.79%

Can there be a macro in excel to find column headers of the excel file in word docs and fill them in excel respectively for all the docx files in a folder. word data/file is not in table format and all docx files are similar

I tried recording the macro but it doesn't work
 

Relevancy 65.79%

What would be the best way to find a specific Column Header, and copy the data found in the column until the column header is found again?
 

Relevancy 65.79%

I have a flat file that when I read it into excel it populates column 1 of each row with data.
This data is actually a series of 5 fields that I need to have in columns and rows, that is,
column a1 thru a5 I need placed in a1, b1,c1,d1 and e1 followed by
column a6 thru a10 placed in a2,b2,c2,d2 and e2.
The data is balanced, that ism there is data in each of the 5 fields for a "record".
Any help would be appreciated.
THanks
 

Relevancy 65.79%

How do I unlock the outline column when I protect the sheet?

Have a spreadsheet in outline form (Data->Group and Outline ...) which, of course, produces a special column to the left of the worksheet that allows expansion or contraction of the rows on the spreadsheet (with a plus or minus sign).

I want to protect the spreadsheet, but still allow this expansion and contraction. However, when I protect the worksheet (tools->protection->Protect Sheet) it also protects this expansion/contraction column
 

A:Solved: Excel 2003 Unprotect Outline Columns

Yep, that to my knowledge is correct.

You cannot protect the sheet and work in group mode.
 

https://forums.techguy.org/threads/solved-excel-2003-unprotect-outline-columns.863710/
Relevancy 65.79%

I have 2 tables where the id in the main table that I need to match with the second table could appear in any one of 3 columns of the second table. I can get the data by created 2 more tables and making three separate queries. Is there any way to create a query that would merge the two tables no matter which column the matching data is in without create 3 separate tables and queries?
 

A:Solved: Excel Query where id matching 2nd table could be in 1 of three columns

After looking at the sql, I just added or statement for the where. I used the same syntax as matching one of the columns and then added an or and changed the column to match to.
 

https://forums.techguy.org/threads/solved-excel-query-where-id-matching-2nd-table-could-be-in-1-of-three-columns.946075/
Relevancy 65.79%

As the title suggests I searched across the interned for something that would allow me to split comma separated cells to columns I came across this code that splits comma separated cells into quot Rows quot Code lt - A - gt lt - B - gt COLOR COLOR a b c a COLOR COLOR d b COLOR COLOR e c COLOR COLOR f g d COLOR COLOR h e COLOR COLOR i f COLOR COLOR g COLOR COLOR h COLOR COLOR i Code COLOR b Option COLOR Explicit COLOR b Sub COLOR Macro Solved: Cells EXCEL: to Separated Comma Columns COLOR b Solved: EXCEL: Comma Separated Cells to Columns Dim COLOR fromCol COLOR b As COLOR COLOR b String COLOR COLOR b Dim COLOR toCol COLOR b As COLOR COLOR b String COLOR COLOR b Dim COLOR fromRow COLOR b As COLOR COLOR Solved: EXCEL: Comma Separated Cells to Columns b String COLOR COLOR b Dim COLOR toRow COLOR b As COLOR COLOR b String COLOR COLOR b Dim COLOR inVal COLOR b As COLOR COLOR b String COLOR COLOR b Dim COLOR outVal COLOR b As COLOR COLOR b String COLOR COLOR b Dim COLOR commaPos COLOR b As COLOR COLOR b Integer COLOR COLOR ' Copy from column A to column B ' COLOR fromCol COLOR quot A quot COLOR toCol COLOR quot B quot COLOR fromRow COLOR quot quot COLOR toRow COLOR quot quot COLOR COLOR ' Go until no more entries in column A ' COLOR inVal Range fromCol fromRow Value COLOR b While COLOR inVal lt gt COLOR quot quot COLOR COLOR ' Go until all sub-entries used up ' COLOR COLOR b While COLOR inVal lt gt COLOR quot quot COLOR Range fromCol fromRow COLOR b Select COLOR COLOR ' Extract each subentry ' COLOR commaPos InStr COLOR COLOR inVal COLOR quot quot COLOR COLOR b While COLOR commaPos lt gt COLOR COLOR COLOR ' and write to output column ' COLOR outVal Left inVal commaPos - COLOR COLOR Range toCol toRow COLOR b Select COLOR Range toCol toRow Value outVal toRow Mid Str Val toRow COLOR COLOR COLOR COLOR COLOR ' Remove that sub-entry ' COLOR inVal Mid inVal commaPos COLOR COLOR COLOR b While COLOR Left inVal COLOR COLOR COLOR quot quot COLOR inVal Mid inVal COLOR COLOR COLOR b Wend COLOR commaPos InStr COLOR COLOR inVal COLOR quot quot COLOR COLOR b Wend COLOR COLOR ' Get last sub-entry or full entry if no commas ' COLOR Range toCol toRow COLOR b Select COLOR Range toCol toRow Value inVal toRow Mid Str Val toRow COLOR COLOR COLOR COLOR inVal COLOR quot quot COLOR COLOR b Wend COLOR COLOR ' Advance to next source row ' COLOR fromRow Mid Str Val fromRow COLOR COLOR COLOR COLOR Range fromCol fromRow COLOR b Select COLOR inVal Range fromCol fromRow Value COLOR b Wend COLOR COLOR b End COLOR COLOR b Sub COLOR I am looking for something that would allow me to do this instead Code lt - A - gt lt - B - gt lt - C - gt lt - D- gt COLOR COLOR a b c a b c COLOR COLOR d d COLOR COLOR e e COLOR COLOR f g f g COLOR COLOR h h COLOR COLOR i i COLOR COLOR COLOR COLOR COLOR COLOR nbsp

Relevancy 65.79%

So....it is me again,
In an earlier thread "blue line" I asked about deleting coninuous columns (not being used in a document) and I was instructed to highlight one column, control, shift, end and this has now twice frozen my application. Any thoughts?

Cheers!
 

A:Solved: Deleting continuous columns freezes Excel

Uh, if you read my post there, you saw that I said it did the same thing to me, so I copied the data to a new workbook and posted it for you.
 

https://forums.techguy.org/threads/solved-deleting-continuous-columns-freezes-excel.743905/
Relevancy 64.93%

Dear guys,

I was wondering if there is a way to change Columns to Text. I know that from the last question i posted here a while back, that we could change a string of text in to many columns. So what i would like to do now is the opposite.

Referring to the excel spreadsheet attached, I basically want to change columns A, B and C in to G.

At first i tried using the formula "=(A3 x B3 x C3)" and obviously that didnt work if not i wouldnt be posting here. How would you pick values up from a cell and then use them in another cell something like =A3 which will bring the value of that cell into another cell. How would you do it for multiple cell references?

Thanks in advance!
 

Relevancy 64.93%

I have a formula (below) that I use to pull the entire contents of a cell of the first occurrence that appears on a row when one of the 15 cells in the row contains PERM. I need a second column formula to find the 2nd occurrence in that same row. Any help would be appreciated.

=IF(ISERROR(INDEX(N2:AB2,MATCH(""*PERM*"",N2:AB2,0))),"""",INDEX(N2:AB2,MATCH(""*PERM*"",N2:AB2,0)))
 

Relevancy 64.93%

EDIT Solved Simple SUMIF worked I thought it was going to be a lot more complicated that that I have an excel spreadsheet which has the following columns Condition Condition Condition etc if a condition is true I set that to a if condition for colums Solved: excel columns in status various suming false a then I have columns with status Status A Status B Status C etc if a status is true I set that to a if false a now i want to report for all conditions the status this works manually using filters and the sum on the status bar Solved: suming status columns for various condition colums in excel so I can filter on condition for then highlight column status A and look at the sum and record the number in the summary Solved: suming status columns for various condition colums in excel sheet then highlight column status B and look at the sum and record the number in the summary sheet then highlight column status C and look at the sum and record the number in the summary sheet etc for all status columns Then I remove filter for condition and I filter on condition for a then highlight column status A and look at the sum and record the number in the summary sheet then highlight column status B and look at the sum and record the number in the summary sheet then highlight column status C and look at the sum and record the number in the summary sheet etc for all status columns and repeat for all conditions I m sure there is a simple formula I can put in the summary sheet to calculate these values I will have to de-sensitive the spreadsheet to post an example - which i will do later today nbsp

https://forums.techguy.org/threads/solved-suming-status-columns-for-various-condition-colums-in-excel.763882/
Relevancy 64.93%

I'm a novice excel VBA macro user. I've manipulated already created macros, but I'm not sure how to create one from scratch. Can someone please help me create a macro.

I'd like to move the values highlighted in yellow to the cells highlighted in green...and then delete any rows that are empty.

Thanks in advance for the help.
 

Relevancy 64.5%

I need to delete multiple columns within an Excel worksheet based on the headers in the first row. What would be the best way to perform this operation?

I have been playing around with the code below, but I feel as though there could be a better way.

Sub test()

Dim myArr As Variant

myArr = Array("Test1", "Test2", "Test3")
If Range("C1").Value = myArr Then
Columns("C").Delete shift:=xlToLeft
ElseIf Range("D1").Value = myArr Then
Columns("D").Delete shift:=xlToLeft
End If

End Sub
 

A:Solved: Excel Macro -> Delete Multiple Columns Based on Criteria

https://forums.techguy.org/threads/solved-excel-macro-delete-multiple-columns-based-on-criteria.835469/
Relevancy 63.21%

Hello I ve long used a simple macro on various spreadsheets to reset the last used cell Sub Reset Range Application ActiveSheet UsedRange End then Excel 2003 range reset to & delete columns rows, macro Solved: blank Sub This works fine but prior to using it I would have to press CTRL End to see where the current last cell is then manually delete any blank columns and rows appearing at the end of the data by selecting them by their column letters row numbers right clicking and selecting Delete Failure to do this would mean the macro didn t successfully correct the last used cell I would like to add this stage into the Solved: Excel 2003 macro to delete blank columns & rows, then reset range macro I found some code on the web that allegedly removes all blank rows and columns so I pasted it at the top of my existing macro Option Explicit Sub DeleteBlankRows Dim Rw As Solved: Excel 2003 macro to delete blank columns & rows, then reset range Long RwCnt As Long Rng As Range Application ScreenUpdating False Application Calculation xlCalculationManual On Error GoTo Exits If Selection Rows count gt Then Set Rng Selection Else Set Rng Range Rows Rows Solved: Excel 2003 macro to delete blank columns & rows, then reset range ActiveSheet Cells SpecialCells xlCellTypeLastCell Row End If RwCnt For Rw Rng Rows count To Step - If Application WorksheetFunction CountA Rng Rows Rw EntireRow Then Rng Rows Rw EntireRow Delete RwCnt RwCnt End If Next Rw Exits Application ScreenUpdating True Application Calculation xlCalculationAutomatic End Sub Sub DeleteBlankColumns Dim Col As Long ColCnt As Long Rng As Range Application ScreenUpdating False Application Calculation xlCalculationManual On Error GoTo Exits If Selection Columns count gt Then Set Rng Selection Else Set Rng Range Columns Columns ActiveSheet Cells SpecialCells xlCellTypeLastCell Column End If ColCnt For Col Rng Columns count To Step - If Application WorksheetFunction CountA Rng Columns Col EntireColumn Then Rng Columns Col EntireColumn Delete ColCnt ColCnt End If Next Col Exits Application ScreenUpdating True Application Calculation xlCalculationAutomatic End Sub However it doesn t work with my current document - pressing CTRL END after running the combined macro takes you to the same last cell as if you hadn t run it Cells in the blank columns and rows at the end have formatting shading cell borders but no obvious data As a test I also tried deleting the contents of column in the middle of the data selecting column and pressing Delete just leaving the cell formatting in place The macro failed to remove that column too So can someone help me get code that actually works in deleting empty columns and rows and resetting the last used cell Ta nbsp

A:Solved: Excel 2003 macro to delete blank columns & rows, then reset range

https://forums.techguy.org/threads/solved-excel-2003-macro-to-delete-blank-columns-rows-then-reset-range.1038197/
Relevancy 60.63%

I am attempting to create a spreadsheet with multiple columns in which each column has a drop down list from which the user can select. My problem is that every time I create a new drop down list for a column, it overides the drop down list I created for the previous column.

Ie:

Column A:
Cell A1-500 Drop Down List
High >31%
Med 15-30%
Low <14%

Column B:
Cell B1-500 Drop Down List
High >4.8
Med 4.3-4.7
Low <4.2

Column C:
Cell C1-500 Drop Down List
High >80%
Med 60-80%
Low<59%

Many thanks to anyone who can help!
 

A:Excel2007 Adding Drop Down List for Multiple Columns

I take it you mean each cell has a drop down list from which the user can select?

If so, I presume you are using data validation and the list option from within it?

This works. You just have to select each column at a time, ie. select column A data range and apply the data validation. Select column B and then apply the data validation...and so on.
 

https://forums.techguy.org/threads/excel2007-adding-drop-down-list-for-multiple-columns.852124/
Relevancy 59.34%

Hi I found the attached vba code on the net and modified it slightly It s Excel Adding Hyperlinks Solved: VBA using purpose is to print all files contained within Solved: Adding Hyperlinks using Excel VBA a folder to WorkSheet of the active WorkBook The code works like a charm However I would like the listed files to be hyperlinks so I could open up each file using the worksheet To this end I recorded a macro that creates a hyperlink as outlined below Sub HyperlinkTest ActiveSheet Hyperlinks Add Anchor Selection Address quot Corrective Action Requests xlsx quot TextToDisplay quot Name of Audito s quot End Sub I then added this into the original code and tried numerous ways to get this to work but to no avail I just can t figure out how to fit this into the existing code to produce hyperlinks instead of just plain text If anyone can help me better understand how I can get this to work the way I want it would be greatly appreciated Thanks nbsp

A:Solved: Adding Hyperlinks using Excel VBA

I've managed to figure out how to tie in the additional code and get the results I wanted. If any one is interested, this is the code that worked for me.

Sub LoopThroughFolder1()
Dim r As Integer
Dim fileSystemObject
Dim FolderObj
Dim fileOBj
Dim arrFileName
r = 2
Sheets("sheet1").Select
Range("a2:f5000").ClearContents
Set fileSystemObject = CreateObject("Scripting.FileSystemObject")
Set FolderObj = fileSystemObject.getfolder("G:\QMS_Files\Record_Logs")
For Each fileOBj In FolderObj.Files 'loop over the files in the folder
If Not fileOBj.Attributes And 2 Then 'only show files that are not hidden
Cells(r, 1).Value = fileOBj.Path
arrFileName = Split(fileOBj.Path, "\")
Cells(r, 2).Value = arrFileName(UBound(arrFileName)) 'Get the File Name

Cells(r, 1).Hyperlinks.Add Anchor:=Cells(r, 1), Address:=Cells(r, 1).Text, TextToDisplay:=Cells(r, 2).Text

Columns(2).Delete 'get rid of extra column
End If
r = r + 1
Next fileOBj
End Sub

The only thing now is to figure out how I can leave the path the way it is, but get the code to read the drive letter in case I move the set of files to another computer with a different drive. Like if I took the whole set of files and put them on a memory stick and then plugged it into another computer which may end up being drive D, E, F, G or H.

Has anyone got any idea of how this could be done?

Thanks.
 

https://forums.techguy.org/threads/solved-adding-hyperlinks-using-excel-vba.1069555/
Relevancy 59.34%

Hi,

I have a bank statement in Excel. What I want is a formula to pick out all the bank charges, for example, and add them in a single cell, so I can tell at a glance how much has been paid. I've attached a sample.

Thanks in advance!
 

A:Solved: Excel - Adding from a list

bleep69 said:


Hi,

I have a bank statement in Excel. What I want is a formula to pick out all the bank charges, for example, and add them in a single cell, so I can tell at a glance how much has been paid. I've attached a sample.

Thanks in advance!Click to expand...

Could not open your example file.

However I believe, your problem can be solved by using SUMIF function.
Lets say when ever there is bank charge the statement is using the term "bank chaarges". Plus this text always appear in column A and the corresponding values appear in column B.
The formula where you want the total for bank charges levied will be:
=sumif(A1:A20,"Bank Charges",B1:B20)
(assuming that the range is the first 20 rows)
 

https://forums.techguy.org/threads/solved-excel-adding-from-a-list.803745/
Relevancy 59.34%

Hello,

I am having trouble with Excel 2003 automatically adding the last digit in a Postal Code. For example, when I type in "R3R 4K5" in A1 and then click the corner of it and drag it down a couple of cells it goes from "R3R 4K5" to "R3R 4K6" and "R3R 4K7" and so on.

Is there an option that you can disable to prevent this?

Thanks!
 

Relevancy 59.34%

I do a weekly report that I base on results that I get with search done in Internet Explorer I can then cut and paste these results into an Excel spreadsheet moving unwanted Rows, Question: rows Solved: Excel to new Removing columns some but I need to delete most of the information whole rows and reorganize the remaining rows by taking the even numbered rows and putting them into the B column then delete that Solved: Excel Question: Removing unwanted Rows, moving some rows to new columns Row as well I have included some images that should help Solved: Excel Question: Removing unwanted Rows, moving some rows to new columns A few more items The information that I paste into the excel spredsheet may contain up to but no more than lines from the original copying source in Explorer I m not sure how many lines that translates into Excel After every records in Explorer there is a quot top quot link that gets copied which needs to be taken into consideration when deleting the extra rows entirely Another way to look at this is that I ONLY want to keep the rows that have the digit number a space then more digits as well as the rows that contain the price with the For instance the first record in my example I ONLY kept amp The price will ALWAYS have a and the first set of number will ALWAYS have digits first no letters Attached is a jpg that shows the various steps the last screen shot has a few of the cells highlighted in the upper left hand side Those highlighted cells is all of the information I need and how I need it presented from the first search records the MLS number and the price Thanks nbsp

A:Solved: Excel Question: Removing unwanted Rows, moving some rows to new columns

https://forums.techguy.org/threads/solved-excel-question-removing-unwanted-rows-moving-some-rows-to-new-columns.814184/
Relevancy 59.34%

Hi,

I am trying to classify and code my inventory items in excel.
My classification sheet contains data in columns which I would like to copy to rows in another excel sheet.
Here is the sample data in ACMOTORS-ATTRIBUTES sheet:

The above sheet has to be converted to columns as in Item_Classificatios_Form sheet :

Can anybody assist me in writing a macro for the same.

Thanks,
mihaufo
 

A:Solved: Excel Macro to convert Rows from one sheet to columns in another sheet

https://forums.techguy.org/threads/solved-excel-macro-to-convert-rows-from-one-sheet-to-columns-in-another-sheet.1045277/
Relevancy 58.91%

In Excel 97 under the Data menue there is a command to convert "Text to Columns...". But, I want to convert "Columns to Text...". How do I do that? [email protected]
 

A:Solved: Excel 97: How can I convert "Columns to Text..."?

https://forums.techguy.org/threads/solved-excel-97-how-can-i-convert-columns-to-text.873596/
Relevancy 58.91%

I have a formula that sums the value of cells within a table depending on their background color...

i'm trying to use this formula but i also want to check if the cells are on a row that is within a certain date range eg. 2014/01/01-2014/01/31.

i've tried using my sumbycolor statement adding an IFS statement to it but excel doesnt like it

if anyone can help thanks in advance
 

Relevancy 58.91%

Urgent need to hear from you more knowledgeable members (i.e., everybody!) as to exactly how to add rows which was so simple in earlier Excel versions, but now is bafflegab. Even after several efforts to comply with what follows when at INSERT, all I got was to move cell I'm in one to the right with all other cells in the row following suite.
OF COURSE I had specified "entire row".

Why this should be so difficult I know not. Please advise ASAP. Thank you.
 

Relevancy 58.91%

I want to add text to the end of the output of a formula in Excel 2010, but can't find the right sintax. I've done this before in Excel 2003, I'm sure the text needs to be double quotes but how to add it to the formula???

e.g. the basic formula could be =sum(A1,A4) where A1=12 and A4=13 and I want it to display 25 apples
 

Relevancy 58.91%

Ok I have tried to figure this one out myself and to no avail.

What I am trying to do is create a macro that would add text at the end of the text in a current cell.

i.e.

Company 1
Company 2
Company 3

I am trying to create a macro that would would go thru each cell and add "Total" to the end.

Company 1 Total
Company 2 Total
Company 3 Total

Every time I try and create a macro, it copies the previous text into the current cell.

Thanx in advance.
 

Relevancy 58.91%

Hi adding (dynamically) excel Need help images Solved: to all I m a newbie here so I appreciate any help that is offered I searched around Solved: Need help adding images to excel (dynamically) the forum here a bit but could not find anything matching my exact needs similar posts used combo boxes or just needed a single picture not quite what I need I m trying to create a product catalog for a client The product info is stored on a database and is being pulled into excel via an excel ODBC Query One of the fields is the image name product jpg product jpg etc The images are stored on the hard drive The list of products will be different everytime depending on what the user filters in the query I need to be able to include the images in the product list Sample fields are ProductId ProductName ProductCost ProductImage I m guessing this will need VBA code to work I m not familiar with VBA coding but with some help I m sure I can get it working Ideally the pictures should show up as x pixels and the rowhight for each row should match the image hight All this needs to be dynamic as one time the query might return rows and another time rows Running Windows XP with Excel Any help is appreciated nbsp

Relevancy 58.91%

Hi, first time poster long time reader...

The problem I'm having is that I need to be able to check for certain values in Col A (i.e. value1, value2, value3, etc) and then add the corresponding values in Col F together for a total.

For example...

A23: Value1 ------------------------- F23: 2
A24: Value2 ------------------------- F24: 9
A25: Value1 ------------------------- F25: 14
A26: Value4 ------------------------- F26: 38
A27: Value1 ------------------------- F27: 5

You'll see there are three cells in Col A set to Value1. I would need a cell to hold the sum of each value in Col F for every row that contains each Value#. The output for Value1 would be 21 (F23 + F25 + F27).
I tried variations of VLOOKUP but that only returns one of the values in Col F and since I need to get totals relative to the Value# in Col A, that doesn't really work.

Thanks in advance!
 

A:Solved: Excel: adding (v?)lookup values

Take a look at the SUMIF function

Regards,
Rollin
 

https://forums.techguy.org/threads/solved-excel-adding-v-lookup-values.719135/
Relevancy 58.05%

Hi guys I Outlook to Adding appointments Solved: Excel VBA with form ve got some lovely code that add appointments to outlook Solved: Adding appointments to Outlook form Excel with VBA However I would like it to check to make sure it s not adding in a duplicate entry I have seen an answer on here but I couldn t get it to work I m not exactly a super user My code is Code Sub AddToOutlook ' Reference to Outlook object library required Dim olAppointment As Outlook AppointmentItem Dim olApp As Outlook Application Dim lngRow As Long shtSource As Worksheet 'Get reference to MS Outlook On Error Resume Next Set olApp GetObject quot Outlook Application quot If Err Number lt gt Then Set olApp CreateObject quot Outlook Application quot End If On Error GoTo Set shtSource ActiveSheet For lngRow To shtSource Cells Rows Count End xlUp Row Set olAppointment olApp CreateItem olAppointmentItem With olAppointment Subject shtSource Cells lngRow amp quot quot amp shtSource Cells lngRow amp quot quot amp shtSource Cells lngRow Start shtSource Cells lngRow Duration Location shtSource Cells lngRow Body shtSource Cells lngRow amp quot to quot amp shtSource Cells lngRow amp quot Departing quot amp shtSource Cells lngRow amp vbNewLine amp shtSource Cells lngRow amp quot to quot amp shtSource Cells lngRow amp quot Arriving quot amp shtSource Cells lngRow BusyStatus olBusy ReminderMinutesBeforeStart ReminderSet True Save End With Next lngRow End Sub Can anyone give me a shove in the right direction Thanks nbsp

Relevancy 58.05%

Hi,

I want to add manually data\formulas to my excel sheet and I get a popup error message:

please see the attached file.

ps: I unprotected the sheet.

Where do I set the flag to allow to add data to my cell. It doesn't allow me to add in some cells. Why is that?.. Some work and some dont..

Thank you
 

A:Solved: error adding data to excel cell.

The cell is "protected" with Data Validation. Activate the cell and go to Data/Validation and either delete the Settings or click the Error Alert tab and set the Style to Warnng or Information.
 

https://forums.techguy.org/threads/solved-error-adding-data-to-excel-cell.694572/
Relevancy 58.05%

Hi everyone,

I have a macro that retrieves some data to excel and populates an excel table (listobject) using vba. The table is large (8000+ rows and 6 columns). There are another table that does some calculations based on the first table. Although the calculations is set to manual, when I send data to the table , I have an impression that the second table is recalculated too, because it takes a lot to add the data (but if I remove the second table it takes just a few seconds compared to 1,5 minutes).
The same is with the table resize.

Can somebody to advice on how to set excel so it calculates everything at the end of the code and not when the data is added to the table. Currently this settings are in place:
Application.ScreenUpdating = False
Application.Calculation = xlCalculationManual
Application.EnableEvents = False

Using Excel 2010 and 2007.
 

Relevancy 58.05%

I have a workbook to keep track of total and monthly sales. Worksheet 1 is Total sales, worksheets 2 - 13 are monthly sales.
If I get a new customer and want to add the record I currently have to add it to every worksheet manually.
I want to be able to add a new row to the total sales and it be automatically added to the other 12 worksheets.
I have tried selecting all worksheets and right clicking but the add new row button is faded out and won't let me click it.
Help?
 

A:Solved: Adding rows to multiple Excel worksheets

Worked it out. I had the data in tables. Converted back to range and it is working fine.
Cheers
 

https://forums.techguy.org/threads/solved-adding-rows-to-multiple-excel-worksheets.982719/
Relevancy 57.62%

Hi guys,

Is it possible to hide certain columns in a worksheet? (Excel 97 on Win98se). We have a spreadsheet that has columns A-G then BF-BJ, then BM-BR. The person that created the spreadsheet is on vacation this week, so we can't talk to them. The person using the spreadsheet now, says there is more information that is needed to get this information currently on the spreadsheet. Is it a reach to think that there may be more info in possibly hidden columns? Aside from renaming columns, is there any other way that someone would go straight from G to BF?

Thanks a lot for the help!

J
 

Relevancy 57.62%

I have some data on Excel. Address numbers are in one column and the street names are in another column. Is there a way I can copy all the information in one column (address numbers) and merge it into another column (street names)?
Rob
 

A:Excel Columns

if the address numbers are in a1 and the street name is in b1, paste =A1& " " &B1 in c1. This will place the number and address in c1.

Tom
 

https://forums.techguy.org/threads/excel-columns.93109/
Relevancy 57.62%

Hi Guys,

Ive opened my excel this morning and instead of there being numbers down the side and letters across the top ive got numbers down the side and across the top so i cant do any statements? Does anybody know what this could be, and why its happened?

Thanks
 

A:Excel columns?

Hi gazmysta,

Tools/Options/General untick the R1C1 reference style box.

BR
Hew
 

https://forums.techguy.org/threads/excel-columns.324254/
Relevancy 57.62%

Ok, look at screen shot below. These are all individual transactions of a sales file. I want to find out how many of each stock number was sold. Is there any way to group these so that it adds the total sales of each stock number? If not, it there a simple equation to do so? I am a total newbie when it comes to excel.

So I want something to look at that tells me I sold 7 of stock # 111 at a quick glance. And so on for each stock number. Any help is appreciated.

Sorry, but please don't question format or why I'm using excel. It is irrelevant. This is imported from our sales file and used just for a quick reference. I just want to be able to tell total sales with grouping or a equation. Its not that in depth.
 

A:Solved: Excel 2002 Simple adding of column with Criteria

How quick is the glance? Select the data, then use Data > Subtotals, with:

At each change in stock number -- use function Sum -- add subtotal to qty. Then you can use the (show level) 2 button below the Name Box.
 

https://forums.techguy.org/threads/solved-excel-2002-simple-adding-of-column-with-criteria.448461/
Relevancy 57.62%

I have created a userform in Excel 2007. Is there a way to obtain and put a digital signature on the userform to show that the form has been entered and/or reviewed by a person. Company has certificates already. I think from Verisign. Ideas?

Thanks in advance.
 

A:Solved: Excel 2007 VBA userform adding digital signature

I don't think the above can be done. I found on a Microsoft Office page the below.

"You can insert signatures lines only into Word documents and Excel workbooks"

Therefore I am assuming that signatures can not be added to a userform.
 

https://forums.techguy.org/threads/solved-excel-2007-vba-userform-adding-digital-signature.984512/
Relevancy 57.62%

Hi there,
I came across this thread (now closed)
http://forums.techguy.org/business-applications/473412-solved-adding-date-time-last.html

Adding Date and Time Last Modified to footer of an Excel worksheet.

It adds the date to each worksheet.
Could someone please show me how to modify it to add the date to each worksheet ONLY IF that particular worksheet has changed?

Thank you in advance.
 

A:Solved: Adding Date and Time Last Modified to an Excel worksheet

Hi there,

Define "change". As in, any change whatsoever? And did you use the workbook before save event? Use a workbook event to get what you want, just use the workbook sheet change event (still in ThisWorkbook module), and be sure you change the activesheet reference (in your linked thread) to the sheet object name (in the parenthesis of the event, I believe it is "Sh"). That should pretty much be it. If you need more help, post your code and tell us exactly what you are looking to do in a little greater detail.

HTH
 

https://forums.techguy.org/threads/solved-adding-date-and-time-last-modified-to-an-excel-worksheet.765388/
Relevancy 57.62%

Hi All,

I'd be very grateful if someone could assist please. I have a column (column C) that contains the sales price and I'd like to show the price with a 20% discount in column D.

I tried to insert a function but I don't know what one to choose!

As you can probably guess Excel isn't exactly my forte.

Most appreciative for any help.

Thanks.
 

A:Solved: Excel: Adding a column to show a discounted rate

So is column D input =C1*.8
the # behind the C is interchangable and should correspond with whichever number is in column C that should reflect the discounted price in column D. Then you are multiplying by .8 b/c that 100-20=80 and you are trying to show the final price I assume. after inputing that in just one row in column D highlight the cell and in the bottom right corner where a square appears hold down you left mouse button and drag down the column. that will populate all the other cells in column D. then you you change any number in column C the number should change in column D. I hope that helps. excel has pretty good help if you type in the help window. if you can't find it there some time i just google for answers.
 

https://forums.techguy.org/threads/solved-excel-adding-a-column-to-show-a-discounted-rate.1000324/
Relevancy 57.62%

Hello group,

I wasn't quite sure how to word the subject line. I would like to be able to add a number to column A everyday and have the cumulative sum of column A show in column B in the adjacent cell so I can chart it. So it would look something like this:

1 1
1 2
1 3
2 5
-1 4

I think it's something to do w/the SUM function but I can't quite figure it out. Any help much appreciated.

Harold
 

Relevancy 56.76%

I need to create this table in Excel, How do I create table like I attached? How do I divide 2 row into 2 columns. Im using mac 2013 office.
please help thx

A:how to divide row into 2 columns in excel

Not sure I follow what you need to do, but....

highlight a group of cells in a row, such as 3A, 3B, and 3C.

Then right click and choose "format cells". Then choose the alignment tab. Then choose "merge cells".

That will combine 3A, 3B, and 3C into a single cell.

Is that what you are trying to do?

You can do the same thing with cells in a column--combine them into a single cell.

You can do that with any combination of cells.

You can then type in whatever you need into a cell and align that typed text to either the left, right, or center of the merged cells.

http://www.sevenforums.com/microsoft-office/337969-how-divide-row-into-2-columns-excel.html
Relevancy 56.76%

If you have Excel data on columns A,B and C sorted by column A, is there a simple way of transposing the columns so you can view the columns in the order of B,C,A sorted by column B, without rearranging the columns by dragging them to new locations?
 

Relevancy 56.76%

Hi I have data on the semiconductor industry of companies and their partners alliances for the years - and - The data is in columns in the following format Alliance ID Company Name Company ID Partner ID Partner ID Partner ID Partner ID The above is for - and - The column Alliance ID assigns a unique ID to each alliance For example if the company Intel has a partnership with other companies Partner ID and Partner ID then this alliance is given an alliance ID XXXXXX It is important to note that this ID is for a given combination of partners i e the same company Intel can have another partnership with some other company different partner ID then this Columns Matching Excel in alliance gets a different alliance ID albeit it being for the same focal company Intel However I only have alliance IDs for the - data and need to generate them for - In other words if a given alliance in - is repeated in - then I need Excel to automatically assign the - Matching Columns in Excel Alliance ID to the corresponding row in - To illustrate In - I can have the following alliance-Intel partnering with Matching Columns in Excel Kodak and Hitachi partner ID and partner ID respectively This alliance can be repeated for - Intel with Kodak and Hitachi Then I want Excel to assign the - Alliance ID to the empty cell of - Alliance ID of the SAME alliance Is there a command or macro program that can do this automatically Thanks Mithuna nbsp

A:Matching Columns in Excel

Can you please upload an example of your spreadsheet (without any sensitive data) so we can see what we are dealing with.
 

https://forums.techguy.org/threads/matching-columns-in-excel.842988/
Relevancy 56.76%

This should be a piece of cake, I just know it! But me and excel never see eye to eye. I have a simple document with column a and column b. I want to find the matching ones and create a column C with the ones that are not matched. Can I do that? Without using copy paste for three hours?? I attached the file below.

Thanks!!
 

Relevancy 56.76%

I have a huge spreadsheet which I am trying to analyse but I really need some help! There is one row of data for each company, then separate columns for products. I need one single column so I can use functions like COUNTIF. A simplified example:

Current situation
Company 1 | Product a | Product d | Product f
Company 2 | Product b
Company 3 | Product a | Product f

Desired result
Company 1 | Product a
Company 1 | Product d
Company 1 | Product f
Company 2 | Product b
Company 3 | Product a
Company 3 | Product f

I am SURE there must be a way of doing this, but I am going round and round in circles right now.... thanks for helping!
 

Relevancy 56.76%

Please help. I need to find a formula that compares any value in one column to any value in another. so for example -

A B
1 3643 6488
2 5378 9087
3 9631 0092
4 4657 9876
(repeat for several hundred lines)

i need a way to find out if any of these are duplicates. i've tried a few formulas i've found on this site but all i've got back is #NAME? when entering them. also, i'm using openoffice, not excel. does that matter? thanks.
 

A:Excel compare columns

This is nothing special. There's a butt-ton of ways.
Here's my article on it.

http://www.officearticles.com/excel/dealing_with_duplicate_records_in_microsoft_excel.htm
 

https://forums.techguy.org/threads/excel-compare-columns.773950/
Relevancy 56.76%

I am having trouble adding the sum of a row across multiple columns I have the code to add teh sum from a single columns but I can't figure out how to make it so it will add the columns up and place the sum on the first empty row The number Multiple Excel of a across Need sum Columns row VBA: of cells in each row is not the same so I need to be able code for that This code is what I use to sum the rows at the end of the column but like I said earlier I need to code it Excel VBA: Need sum of a row across Multiple Columns so it will go to the end of the row while adding all cells in the row from multiple columns Option Explicit Sub StatsEachColumn Dim LastColumn As Long LastRow As Long Excel VBA: Need sum of a row across Multiple Columns lngColumn As Long LastColumn Cells Find What quot quot After Range quot A quot SearchOrder xlByColumns SearchDirection xlPrevious Column For lngColumn To LastColumn LastRow Cells Rows Count lngColumn End xlUp Row With Cells LastRow lngColumn FormulaR C quot SUM R C R quot amp LastRow amp quot C quot End With Next lngColumn End Sub

A:Excel VBA: Need sum of a row across Multiple Columns

Forgot to mention that it will need to loop since there are 4 different rows so far and it will need the ability to work with any added rows

http://www.techsupportforum.com/forums/f57/excel-vba-need-sum-of-a-row-across-multiple-columns-1070562.html
Relevancy 56.76%

I would like to do a loopy using Macro.xls
Let say,
1-start at column 13 do sorting ascending
2- find duplicate ( macro FindDup())
3- next column ... until column IV
and her my Macro record modify by me (!!)

Dim y As Integer
Dim rng As Range

For y = 13 To 255
rng = Cells(1, y).Select
Rows("1:3013").Sort Key1:=rng, Order1:=xlAscending, Header:= _
xlGuess, OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom, _
DataOption1:=xlSortNormal
Application.Run "CP.xls!FindDup"
Cells(1, y).Select
Next y
End Sub
I get error :
Run time error 91.(object variable or With block variable not set.
Any help ?? Thanks in advance.
 

Relevancy 56.76%

I am trying to insert a column in my spreadsheet, but I keep getting the following error message:

To prevent possible loss of data, Microsoft Excel cannot shift nonblank cells off the worksheet.

I don't know why I continue to get that message in this particular spreadsheet. I tried copying and pasting in a new workbook, but it still doesn't insert the column.

Does anyone know what could be wrong?
 

A:Excel....inserting columns

Never mind. I was finally able to insert the column. I still don't know what the problem was, but I tried copying and pasting again and it worked.
 

https://forums.techguy.org/threads/excel-inserting-columns.226144/
Relevancy 56.76%

Ok, so i have an excel sheet with a number of columns that i need a formula for to calculate another value in another column in the same sheet. Column A is the one which needs the formula. The data in Column A needs to be a string which looks like this:

GCSO00MNI000

And then needs to have additional characters added to the end which are the values found in column C, such as "107". Therefore, column A's value for that row would be GCSO00MNI000107. The same calculation needs to take place for the next row in Column A, completing it's string with the value in the next row in Column C, and so on and so on, for 6500 rows.

How do i do this and not have to retype the needed calculations for all 6500 rows?

thanks in advance.
 

Relevancy 56.76%

My english is bad. But try to understand and help me!!!

I need more columns to Excel 2000 or XP. The max account is 256 columns and I need 500 columns.

Windows 98 or 2000.
Excel 2000 or XP.
 

A:I need more columns EXCEL 2000/XP

Hi

I'm afraid you're out of luck. 256 is all you've got. It's debatable whether MS will increase this in the future, but don't hold your breath.

Just curious, why do you need 500 columns? Perhaps there is another way round your problem?

Regards
 

https://forums.techguy.org/threads/i-need-more-columns-excel-2000-xp.305967/
Relevancy 56.76%

I have three columns of information. Column A is 900 part numbers with no prices, Column C is 600 part numbers matched with their respective $ value in Column D. I need a formula to match the part in column A with the like part in column C and find the $ value from Column D and place that $ value in Column B next to its respective part number. Can anyone help me with this? Thanks so much!!
 

Relevancy 56.76%

My excel has columns ad infinitum. I only need through column J. How can I get rid of the other columns so that I can print only through J? Thanks to all who know so much and take time with folks like me who know so little.

A:deleting columns from excel

you should be able to set the print area
what version of excel do you have

I have moved to the office forum

http://www.techsupportforum.com/forums/f57/deleting-columns-from-excel-681621.html
Relevancy 56.76%

How do you alter column placemens in Excel so that Column 2 changes places with Column 1?
 

A:Transposing Excel Columns

if I understand you correctly, all you need to do is to cut column A (rows are numeric, columns alphabetic), click on the column after column b, and click insert cut cells.

again, that is if I understand you correctly. Please advise if this works.
 

https://forums.techguy.org/threads/transposing-excel-columns.414182/
Relevancy 56.76%

if I click on the column at the very top it will highlight the column, then I can drag and drop it somewhere, but it overwrites the column where I dropped it. how do I keep it from doing that?

its a CSV file im working with. I have another CSV viewer where I can easily drag and drop columns. but the problem with that one is the first line is not comma seperated, so I have to open it with notepad and remove the first line before I can view it errr...
 

A:moving columns in excel?

Create a blank column into which you can drag/drop the target column

letchworth
 

https://forums.techguy.org/threads/moving-columns-in-excel.555855/
Relevancy 56.76%

I have formulas that has the data setup in rows (input). The next sheet is formulas that are in columns referencing these individual rows (output). When column A's formulas are dragged to column B, the references change as expected but to Sheet1!B1 rather than Sheet1!A2 (back to the rows). I think I 've done this before, but can't for the life of me remember how. Help me please and I'll be your best friend! (hey, it's the best I can do).

thanks,

drew
 

A:Excel Columns to Rows

Select all the cells involved

Right click anywhere on your selection and from the menu that pops up choose Copy

Click in the cell where you want the list to begin then Right click and from the menu choose Paste special you will now see another menu.

At the bottom right hand side of this menu, Select Transpose.

That's it your list will now run across the page instead of down
 

https://forums.techguy.org/threads/excel-columns-to-rows.210075/
Relevancy 56.76%

I am having trouble figuring out how to split some data into separate columns. I have a column that holds numeric dates (example: 01/01/04) - I would like to use the text to columns tool to split this into 3 columns (example: column 1 "01", column 2 "01", and column 3 "04"). It looks like it should be able to do it from the example grid, but it is not working. Can anyone give me step by step instructions with which boxes to check etc...?
 

Relevancy 56.76%

I need to sort columns in Microsoft excel but here is my dilemma I am having. I need them to be sorted based on the first column alphabetically. Which I understand requires just hitting the sort button.

However.. my grid looks something like this

NAME Hours Address
Tom 6 10 B Street
Bob 3 30 Smith Lane
I want to sort by Name alphabetically. But I want the addresses and hours to also sort along with it. So for example when Tom's name is moved below Bob's I want his hours and Address to also move with it. So everything stays organized. How would I do that?
 

A:Sorting Columns in Excel

Select all three columns before doing the sort (DATA --> SORT)

Regards,
Rollin
 

https://forums.techguy.org/threads/sorting-columns-in-excel.591076/
Relevancy 56.76%

I'm using Excel 2010.
I have a workbook with TWO Tabs (sorry, cannot attach).
First Tab, the data - Second Tab, the form I want generated.

In the first Tab, Column A is a date. Columns B and C are TEXT Data
For the second tab, I want to create formula that reads like this:

If first tab Column A = a specified date, then bring in the information in first Columns B and C.

If the date appears five times, can it bring the information in and create five rows? (or am I restricted to only cell to cell formulas?)
It sounds like I should just do a simple cut/paste sort of thing and not create a difficult formula, but I really need a formula, because ultimately it will be expanded beyond two simple tabs.
 

Relevancy 56.76%

Please HELP,

This problem's going way beyond my excel knowledge. and beyond my friend "ASAP utilities"
Can someone please tell me how to merge 2 Column using a key factor " i.e number".

Here I have 4 column's total.
The left 2 have the correct order/ The Right 2 are in the wrong order.
I need to fix that using their common factor/#.

I have attached the file here.

I would be very happy to fix this ASAP.
How do I do it???

Thanks

Brion Dublin
 

A:help merging columns in Excel 03 !!!

I have made some mods to your sheets as follows

I created a reference table by
extracting the number part from column E using Find looking for a space and then using Mid to select the number - see the cacl for ref table
Then created a reference table tab - to use as a lookup
Then on sheet1 used vlookup to get the column D & E to align with column A
 

https://forums.techguy.org/threads/help-merging-columns-in-excel-03.688943/
Relevancy 56.76%

I would like to merge two columns in excel, to create a third column that has alternating cells originating from the first and second column.

To make it a little clearer: I have values in column A and B

In column E, I would like to see the following result:
E1 = value of A1
E2 = Value of B1
E3 = value of A2
E4 = Value of B2
E5 = value of A3
E6 = Value of B3
...

The attachment to this post contains the result I want to obtain.
 

Relevancy 56.76%

Has anyone ever encountered missing columns in Excel? I received an Excel file from a co-worker and the columns are lettered from A to H, then L, then from T on. I have never seen a spreadsheet with missing columns before. I am having problems printing the spreadsheet because it cuts off after the L column. My guess is that there is a page bread in one of the missing columns. Can anyone help me with this?
 

A:Missing Columns in Excel

Click on the top left box, where the rows and columns meet. That should select everything. Then right click on one of the rows or columns and choose unhide rows/columns. That's it

BTW
:wave:Welcome to TechSpot:wave:
 

http://www.techspot.com/community/topics/missing-columns-in-excel.28333/
Relevancy 56.76%

Hello,

Could you please help me with the following question. I have a simple division formula (=A1/A2) and would like to add a symbol, "x" after that, so the format of the cell would be: 1.23x. My problem is that I can't use & "x" because the format of the number (2 decimal places) no longer holds, and I get something like: 1.234445555x if I use (=A1/A2 &"x").

Could anyone please help me with the solution?

Thank you!

Alexis
 

A:Solved: Excel - adding a symbol after formula and keeping format of the number

This should work for you.

=ROUNDDOWN(A1/A2,2)&"x"
Rollin
 

https://forums.techguy.org/threads/solved-excel-adding-a-symbol-after-formula-and-keeping-format-of-the-number.1076909/
Relevancy 56.76%

Is there a way to add Date and Time Last Modified to an Excel worksheet footer, so I can can tell from the various "work in progress" hardcopy printouts what is the latest version?

Thanks-Jamie
 

A:Solved: Adding Date and Time Last Modified to footer of an Excel worksheet

https://forums.techguy.org/threads/solved-adding-date-and-time-last-modified-to-footer-of-an-excel-worksheet.473412/
Relevancy 56.76%

Hi all I m working on a new workbook and I m having trouble working-out exactly what I need to do to achieve the following I have two worksheets in my workbook The first worksheet has a list of codes budget reference numbers in rows and columns for each month within the financial year Within the cells that intersect 2010 Microsoft Solved: Data Adding & Within Searching Excel Specific with these rows and columns I want to show dollar Solved: Searching & Adding Specific Data Within Microsoft Excel 2010 amounts that display the amount of money remaining Solved: Searching & Adding Specific Data Within Microsoft Excel 2010 in each budget Solved: Searching & Adding Specific Data Within Microsoft Excel 2010 In my second worksheet I have a populated list of expenses one expense listing per row all assigned with one of the codes I mentioned before Now what I would like to happen is for each cell intersecting with a code and month in the first worksheet to search through the second worksheet for any listings that fall within that particular month and that particular code then adding them together and producing the result I m not sure I ve explained this particularly well but any help that could be offered would be greatly appreciated nbsp

A:Solved: Searching & Adding Specific Data Within Microsoft Excel 2010

https://forums.techguy.org/threads/solved-searching-adding-specific-data-within-microsoft-excel-2010.1067193/
Relevancy 56.76%

Hi all,

I'm looking for a way in either Excel or Word 2010 to add text to a line before the text. So, for example I have something like this:

Name1
Name2
Name2
etc..

And then I want to add "1 " before each line in a way that is copy pastable, so it looks like so:

1 Name1
1 Name2
1 Name3
etc..

Is there anyway to do this. it's mostly just to help with copying text from Word/Excel documents onto forums so it formats correctly. Any help at all is much appreciated

Cheers,
Matt
 

A:Solved: Word/Excel 2010 Adding text before each line in a Document

Hi Matt,
It's probably a little cleaner to do it in Excel than in Word, but also a few extra steps. In Word:

You can run a find a replace. Without including the quotes, find "^p" (the paragraph symbol) and replace with "^p1 " (there's a space after the 1). This replaces the paragraph break at the end of each line with another paragraph break and then "1 " at the beginning of the next line. The problem with this method is that the first line won't have a 1 in front of it (because there's no paragraph break before that line) and the last line will have a stray 1 after it. But this should be relatively minor cleanup.

Alternatively, in Excel:

Insert a column to the left of your names. Without including the quotes, enter "1" in the first cell and copy it down your spreadsheet. Insert a column to the right of your names and enter this formula (assuming your names are now in column B):

=A1&" "&B1

This should give you the result you're looking for in column C. Hope that helps.
 

https://forums.techguy.org/threads/solved-word-excel-2010-adding-text-before-each-line-in-a-document.1076635/
Relevancy 56.76%

I have been working on a project for a few weeks and I could really use some help I m attaching a dummy file example that is an example of how my XLS comes to me each month I need a Solved: to delete specific XLS Macro move to columns rows/columns rows. and macro that leaves me with the second file example If the macro could just grab the Student name then put the following info for each student all on row that would be perfect Child s Name Date In Time In Rounded Time Out Rounded Sometimes for some reason there is a student with Solved: XLS Macro to delete specific rows/columns and move columns to rows. a Cont after their name I need that row deleted and just pull the times up onto the same row as other times The example file might make sense Here are the steps I am doing manually that I hope a macro could do for Solved: XLS Macro to delete specific rows/columns and move columns to rows. me Un-merge cells B Un-merge any cells with a child s name such as Doe Jane Delete any row with a childs name that has Cont after it such as Doe Jane Cont Delete rows - Delete columns A C F H I J M N O and P Manually move all info up to one row per student Delete all empty rows below See example as the completed file but I only moved a few of the rows per student for the sake of time Is there any way to do all of this with a macro nbsp

A:Solved: XLS Macro to delete specific rows/columns and move columns to rows.

https://forums.techguy.org/threads/solved-xls-macro-to-delete-specific-rows-columns-and-move-columns-to-rows.1021890/
Relevancy 56.33%

I have a data base that is listed in one column and would like each address have one row and as many columns as needed.
each data set has 6-8 rows with a empty cell between each data set. I would like a macro to automate this process...
sample below:
AAA & Associates (The Arther Law Firm)
1221 Ave. of Americas,42nd Flr.
New York, NY 10020-1001
Tel212) 713-0138
[email protected]
Mng. Partner:Anthony Afther, Esq.;Law Clerk/Opns. Mgr.:Mike Murphy
www.artherlaw.com

Daniel J. Aaron, P.C.
420 Lexington Ave., Ste.902
NewYork, NY 10170
Tel212) 684-4466
Fax212) 684-5566
[email protected]
Attorneyaniel J. Aaron,PC
www.djaaronlaw.com

Abrams Garfinkel Margolis Bergson, LLP
237 W.35th st.,4th Fl.
New York, NY 10001
tel: (212) 201.-1170
Fax212) 201-1171
[email protected]
Partner:Bill Abrams
www.agmblaw.com

Ira Abrams
1839 S. Ocean Blvd.,Ste. 28
Delray Beach, FL 33483-6583
tel561) 276-4900
fax561) 276-4488
[email protected]
Attorney:lra Abrams, Esq.
 

A:Excel address groups to columns

Assuming that
1) the data is in column A, and
2) there is an empty cell between consecutive records
the code below should work. It will put the transformed data into column C and to the right.
Code:
Sub test()
Dim rng As Range, c As Range, tgt As Range

Set rng = Union(Range("A:A").SpecialCells(xlCellTypeBlanks), Range("A" & Rows.Count).End(xlUp).Offset(1))
For Each c In rng.Cells
On Error GoTo NextCell
Range(c.Offset(-1), c.Offset(-1).End(xlUp)).Copy
Range("C" & Rows.Count).End(xlUp).Offset(1).PasteSpecial Paste:=xlPasteAll, Transpose:=True
NextCell:
Next
End Sub
Jimmy
 

https://forums.techguy.org/threads/excel-address-groups-to-columns.992428/
Relevancy 56.33%

Hi,
I could really use help on the following-- I have huge excel files that need to be rearranged into proper format. Currently they are in this format (using a very simplified example):

Column 1 Column 2 Column 3
Person1 socks 3
Person1 pants 4
Person1 ties 10
Person1 hats 6
Person2 socks 2
Person2 pants 3
Person2 ties 1
Person2 hats 7
Person3...
The format I would like to have is as follows:
Column 1 Column 2 Column 3 Column 4 Column 5....
Person1 Person2 Person3 Person4
socks 3 2
pants 4 3
ties 10 1
hats 6 7

... and so forth.

I'm not very handy with Excel and am wondering is there anyway I can automate this task to save myself a lot of cutting and pasting? I have huge amounts of data, it's akin to processing 500 people with over 10,000 clothing items.
Thank you so much in advance.... this would really save me weeks and weeks of time.
 

A:Dividing a huge Excel row into columns- pls help!

The thing to do would be to write a macro in VBA, I might be able to make one for you but I'll need to know all the different categories of thing (hats, ties etc.) and whether each person comes up the same number of times, one after another, or whether its random, because it could get too complicated and time consuming to be able to help.
 

https://forums.techguy.org/threads/dividing-a-huge-excel-row-into-columns-pls-help.959728/
Relevancy 56.33%

I am a novice at excel I have A 2003 columns Excel Combining in throught A as first names and B through B as last names in a spread sheet I want to make a column of First and Last Names together either by itself like a new column C or Combining columns in Excel 2003 by utilizing either A or B columns I have found the formula A amp quot quot amp B but I don t know what to do with it When I paste that formula into C of a blank column C it gives me first and last name of A and B but how do I get this to replicate itself down the column C to change all seperate first and last names into one cell each containing first and last names Sorry if this is a very basic question but I simply am not that familiar with how excel formulas work yet and how to get them to work over multiple cells Thanks for your help in advance LettuceChat nbsp

A:Combining columns in Excel 2003

Leave the =A1&" "&B1 formula in C1. Place your cursor over the bottom right corner of cell C1. It should change to a thin "+" sign. Press and hold down the left mouse button. Drag the cursor down to cell C226 and release the mouse button. This should copy the same formula structure into each cell in column C while incrementing the row number references.
 

https://forums.techguy.org/threads/combining-columns-in-excel-2003.519782/