Windows Support Forum

Solved: comparing data in two columns in Excel

Q: Solved: comparing data in two columns in Excel

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

Relevancy 100%
Preferred Solution: Solved: comparing data in two columns in Excel

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.)

Relevancy 84.32%

I am having two column with current month profit & last month profit respectively Column A & Column B. I would like to compare both column & set the ICON (down Arrow & up Arrow ) based on result if A1 value greater than B1 set upper arrow else down arrow

A:How to set ICON in Excel by comparing data in 2 Columns

You didn't say where you wanted the arrows to appear, so I'll use C1 for this explanation.1 - In C1, enter this formula: =IF(A1>B1,2,IF(A1=B1,1,0))2 - Under the Conditional Formatting drop down, choose Icon Sets and then choose the Up arrow.3 - Go back into Conditional Formatting and choose Manage Rules4 - Edit the Rule for C1 as follows:----- Click the Show Icon Only box to place checkmark in box----- Change Type to be Number in both dropdowns----- Up Arrow: when value is >=2----- Sideways Arrow: when <2 and >0----- Down Arrow: when <=0 (should be default)5 - Click OKLet me know how that works for you.Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

http://www.computing.net/answers/office/how-to-set-icon-in-excel-by-comparing-data-in-2-columns/20422.html
Relevancy 106.64%

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 106.64%

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 93.74%

Hello,
I am trying to find the minimum number out of a set that has a certain label entered beside it. For example:
Number of OrdersCompany
993 BananaCorp
1200 ZoomZoom
500 Banana Corp
43664 Omletted Way
545 Tomato Inc

I want to find the least amount of orders taken from BananaCorp

Thanks!!!
 

A:Excel - Finding the minimum number while comparing two columns

You have two columns, Orders , Company

Orders Company
500 Banana Corp
993 Banana Corp
43664 Omletted Way
545 Tomato Inc
1200 ZoomZoom

SOrt on Company as a first key and Order as a 2nd Key.
for a visible max order per company.
It's a beginning.
 

https://forums.techguy.org/threads/excel-finding-the-minimum-number-while-comparing-two-columns.758382/
Relevancy 92.45%

Hi Hopefully one of you delightful people can help Comparing/Matching Excel & worksheets more in across Solved: data me with a small problem I m having pulling together data from multiple reports I have manually combined separate reports Solved: Comparing/Matching data across in Excel worksheets & more into workbook with worksheets for each report Each row represents a separate job The st worksheet is an export from our own Access database the others come from external reports Whilst each report worksheet contains different sets of data column in each worksheet contains amp CSR amp or amp Site ID amp numbers These numbers can be used to match the jobs - however a not every worksheet has every number b some numbers may appear more than once on the same worksheet these are essentially returns to the same job The st Solved: Comparing/Matching data across in Excel worksheets & more worksheet also has a column with OPID numbers Column A these are unique numbers that we have paired to a CSR or Site ID number I want to compare the numbers in the CSR column of the st worksheet Column B of Sheet with the CSR columns in the other worksheets and where there is a match copy add the corresponding OPID number to a blank column in each worksheet What would be the best way to do this Thanks in advance for any help and advice offered nbsp

Relevancy 88.58%

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 88.58%

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 88.58%

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 87.72%

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 87.72%

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 86.86%

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 83.42%

Hi,

I'm working on a comparison of 1 list of mixed names against a list of first names and a list of last names.

When I put in this: =COUNTIF(Sheet2!A2:A36,"Jackie") it works

When I put in this: =COUNTIF(Sheet2!A2:A36,A154) it does not work

I much prefer to be able to set up the formula, with an absolute range, and autofill.

I have tried using Text and General formats for the columns and this doesn't seem to make a difference.

I appreciate your help.

Tester
 

A:Solved: Problem with CountIF comparing columns of names

Solved: one list had a space at the end of each name, so the match was not exact e.g. "Jackie " vs "Jackie"
 

https://forums.techguy.org/threads/solved-problem-with-countif-comparing-columns-of-names.1044421/
Relevancy 83.42%

I'm using Excel 2007, Windows vista. I need to compare actual costs (sheet 1) and estimated costs (sheet 2) to get the cost variance (sheet three) I'm getting really wacked out numbers using consolidation, but I have no idea what I'm doing
 

A:excel - comparing two worksheets to get data for a third

May I assume that the rows in Sheet1 and Sheet2 are not the same?
There must bbe a common denominator against which you want / can compare the costs?
A simple sample would help give the picture of the actual situation.
 

https://forums.techguy.org/threads/excel-comparing-two-worksheets-to-get-data-for-a-third.985438/
Relevancy 83.42%

Hi,

I have the following challenge: I need to compare two excel files and check if certain identification numbers of participants in the one file are also present in the second file. The first file contains the identification numbers of the people who were invited to complete a questionnaire (SampleMapLookUp) and the second file contains the data of the questionnaires that were sent back (SampleFileBase). Is there a way to automate this process? In annex two sample files: SampleMapLookUp is the file with the numbers (name of the column is "ID_IND") that I want to check in the second file: SampleMapBase (name of the column here is "his_1").
I don't know if it was necessary but for testing sake I marked the numbers that should be found in yellow in the SampleMapBase. The resulting file should ideally have the lay-out and content of SampleMapLookUp.

Thanks for any advice,

Eddy
 

Relevancy 82.56%

Hi All,

i want to compare data between two work sheets of one workbook and if data matches then it will be copied to third work sheet automatically. can some body help me.

Thanks
Kapil
 

Relevancy 82.56%

hi guys, I have different data sets from two different software programs these two programs share data.these are bookkeeping entries. debet creditbank 100bank1 200.18soft 100soft 200.18the first data set consist of the last two entries of soft but then like a a lot of entries of soft. the second data set consist als of soft debet creditsoft 300.18person1 100person2 200.18i have to match soft of the first data set that consist of soft 200.18 and 100 with the second data set dat consist of the same soft but the sum of the individuals soft.can sombody give me an idea on how to look at these problems in excel.

A:excel challenge comparing two data sets

We probably have a language issue here, so it may a few tries before we can offer a solution. At this point I am totally confused by your request. Perhaps you could post some more examples of your input along with the desired output. We want to help, really we do!Please click on the following line and read the instructions on how to post example data in this forum. Thanks!Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

http://www.computing.net/answers/office/excel-challenge-comparing-two-data-sets/19862.html
Relevancy 78.69%

I'm trying to find a way to delete some data from a column, say column A. The numbers to be deleted are in another column, column B. Is there a way to have excel remove from column A, those numbers that appear in column B? It would require some way to compare, but I can't figure out if excel has this capability. If the columns were small, we could do this manually, but the data set is huge, with several thousand numbers.

Thanks for any help.
-wayne
 

Relevancy 78.69%

Is it possible to fetch some lines of data from a group of web pages and paste in to Excel?Pls view the image for required excel columns.

urls are,
Stock Share Price dlf ltd | Get Quote dlf | BSE
Stock Share Price dlf ltd | Get Quote dlf | BSE
Stock Share Price jaiprakash associates ltd | Get Quote jaipra | BSE
------------
-----------
up to 100 urls in a text file.

A:Web site data to excel columns

When you right click on the webpage and select "View source" from the context menu - do you see the info of interest; I don't. If the info were there, you could use InetGet. They know the value of the info being presented and they probably want to discourage automated data mining.

See if there is a mobile version of the webpage.

http://www.sevenforums.com/browsers-mail/295491-web-site-data-excel-columns.html
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 77.83%

Helloooo
I have two columns of data. In column A, I need to identify every cell that is identical to any value in column B.
 

Relevancy 77.83%

I m hoping there 2 3 columns compare EXCEL files data in is a formula within EXCEL that will allow me to complete this comparison I ve been working on it all day manually and realize it will take a long time to complete this way My computer is running on Windows Home Premium and my EXCEL is I have two different files and within each are three columns of data that I need to compare They re labeled NC NCI and SECNCI To be considered a match I need all three fields within a row to match exactly to a row within the other file The first file called REQUEST NET FILE has over rows of data so naturally there will be many repeats of these same three fields in that file but each row where the three fields match any row of data on the second file called DEPLOYED TABLE FILE needs to be the same to be considered a match If it doesn t match if possible I d also like to know why This could fall into two different scenarios NC CODE IS NOT ON DEPLOYED TABLE FILE or NCI SECNCI combo not on deployed table for this NC Once complete I ll run the same process in reverse so both files will end up with a match or no match next to each row If I need to run two separate compares one to EXCEL 2 files compare data in 3 columns get the match and then one on just the no match results to find the second bit of info I can do that Or if the second criteria can t be found via excel formula just the match no match result will be acceptable as that will save me so much time I was thinking a vlookup could do the compare for me but I m not good with vlookup formulas and after struggling a few hours with it I started searching and came across your site I ve found a few similar topics but nothing that I can translate into something for my specific need I ve attached portions of the two files and you can see on the REQUEST NET FILE where I ve managed to get to with doing it manually It s quite a tedious process so I m really hoping you can help Thank you Tech Support Guy System Info Utility version OS Version Microsoft Windows Home Premium Service Pack bit Processor Intel R Celeron R CPU GHz Intel Family Model Stepping Processor Count RAM Mb Graphics Card Mobile Intel R Series Express Chipset Family Mb Hard Drives C Total - MB Free - MB Motherboard Dell Inc G F Antivirus McAfee Anti-Virus and Anti-Spyware Updated and Enabled nbsp

Relevancy 77.83%

Hi A does anyone know how to search for the text content Searching Rows/Columns EXCEL Data in of a cell through a column and then return the value content of the cell of a certain other column of the same row where the text content was found e g A B C D T XY TP YZ TP ZY P YX TP YY FORMULA TP ZZ gt gt FORMULA EXCEL Searching Data in Rows/Columns quot Look for string TP in column A other than in EXCEL Searching Data in Rows/Columns row and return the value of that row in column C C YZ quot NOTE There might be more than row with the string TP in column A - I would need the sum of all results in column C where the FORMULA finds this string B I also have a similar problem with another worksheet It would require a formula which searches through a whole column for certain names e g quot Donna quot and then returns the value of another column in the same row where it found quot Donna quot the value again is not in a column directly EXCEL Searching Data in Rows/Columns adjacent to the column where quot Donna quot would be found This is fairly identical to problem A except that the search string would be unique only result and it doesn t have to take into account and disregard if the string was found in the same row of the FORMULA the search column would be in a different worksheet from the FORMULA worksheet Thanks for any suggestions Cheers from New Zealand Andreas nbsp

Relevancy 77.83%

Hi,
I have an excel sheet with 3 columns. What I want to do is, I need to be able to find value in column 3, that corresponds to a value in column 2. The value in column2 should match the value in col 1.

Example

Input Data
Col1 Col2 Col3
1------2------A
2------7------B
7------1------C
5------9------D

The result should be
Col1 Col2 Col3
1------1------C
2------2------A
7------7------B
5------9------D
Please help me.
 

Relevancy 76.97%

We have a survey package which is great, but it out puts the questions numbers over the columns and each new row is a response, however our calculations are setup for the question numbers to be the rows and the responses are the columns. Is there any way to swap these values around in this fashion? Thanks for any help
 

A:Excel: swapping columns and rows layout of data?

Howdy. You can copy the data, then Paste Special > Transpose
 

https://forums.techguy.org/threads/excel-swapping-columns-and-rows-layout-of-data.456591/
Relevancy 76.11%

Hi all,

I have an excel sheet attached as an example. What I want to do is
take the data in each column and put them together into one
column.

In my attached excel sheet I would like to have the data in each
column look like this in one separate column each line for example 1-72-bk-1803

any help is appreciated....thanks
 

A:Excel question: how would you connect data in defferent columns into one column?

In E1 enter
=A1&"-"&b1&"-"&c1&"-"&d1
copy down
 

https://forums.techguy.org/threads/excel-question-how-would-you-connect-data-in-defferent-columns-into-one-column.934495/
Relevancy 76.11%

Hi all I have a spreadsheet that holds sports results based on age groups The age groups are in one column stored as U B U G U B U G U B U G which is the age B or G boy girl The results are in another column stored as whole numbers I am trying to find a formula that will allow me to sort on the first column in the order shown above and then on the second column in descending order and then bring back the other data like the name example Child A U B Child B U G Child C U B Child D U G Child E U G would be returned as U B Child C U G Child D U G Child B U G Child E U B Child A I know I can use a manual sort but I was hoping to automatically put the results in a separate sheet in the correct order Any ideas Thanks in advance nbsp

A:Excel - function to sort multiple columns of alphanumeric data

You could easily enter in this formula:
=IF(LEN(B1)=3,LEFT(B1,1)&"0"&RIGHT(B1,2),B1)
(where the three data columns are just A, B, and C) so that you get - instead of U6B, for instance - U06B. This allows you to sort correctly by age.
If you want it copied and sorted to another page like that, you really need a macro/VBA.
 

https://forums.techguy.org/threads/excel-function-to-sort-multiple-columns-of-alphanumeric-data.933917/
Relevancy 76.11%

Hi,

I was hoping somone could please help me out.

I have an excel spread sheet with a lot of data in columns which i need to convert into rows. The problem is one column contains over 10,000 rows of data... thus making it too hard to transpose manually.

I have attached a copy of the spreadsheet (condensed version) and was hoping someone had some suggestions on how i can achieve my desired outcome.

Thanks very much,

Ray
 

A:Move alot of Data from Columns Excel 2010 - too big to transpose

I'm sorry to say that this is pretty much impossible as far as I can tell because there simply isn't enough consistency in your layout. If all rows were there and in order it would be easy enough.
As they aren't, one would need to inspect the titles to put them in the right place, but your titles don't always match either. For example your second "Telephone" entry is actually titled "Clinic Mobile", which the computer justly sees as very different indeed.
I'll try to help if I can, but you'll need some point of consistency if you want computers to automate a process. If it helps, here's a copy of my spreadsheet that inspects the titles (on sheet 2). If there are only a few problematic titles it might be easier to correct them manually (or use search and replace).
 

https://forums.techguy.org/threads/move-alot-of-data-from-columns-excel-2010-too-big-to-transpose.981919/
Relevancy 76.11%

Hi I amp m trying to work out how I can look at one column in a spreadsheet and display the text in another field but without a load of blank cells in the results column Let me give you an example On Sheet In column A are road names In column B the number of building on that to from multiple one data column 2010 Excel columns separating road In column C the last date and work was doneon the road In Column D is an IF formula thatbasically gives a result of Excel 2010 separating data from one column to multiple columns or On another sheet I want four lists Sheet In column A is a list of road names thathave a value of in Sheet column D In column B is a list of road names thathave a value of in Sheet column D In column C is a list of road names thathave a value of in Sheet column D In column D is a list of road names thathave a value of in Sheet column D I can do this with a simple IF statement in columns A B C amp D on sheet and drag it down but there are a couple of problems with this method If the value in sheet doesn amp t match I get a blank cell on sheet as there should be but this leaves a large number of cells with no value I need a list in each column A B C amp D onsheet without any blank cells I amp m going to be pasting different data into columns A B amp D on sheet a number of times and the number of rows in will be different each time I remember seeing something before thatinvolved using the IF and COUNTIF function in a formula but not sure how Any help would be appreciated nbsp

A:Excel 2010 separating data from one column to multiple columns

should be able to use an array formula - so use control + shift + enter key and the formula gets { } brackets

Code:

=INDEX(Sheet1!$A$2:$A$14,SMALL(IF(Sheet1!$D$2:$D$14[COLOR="Red"]=1[/COLOR],ROW(Sheet1!$A$2:$A$14)-ROW(Sheet1!$A$2)+1),ROWS(F$4:F4)))
where you change the red =1
to =2, 3, 4 for different columns

does that work out

see attached

if it works we can extend the range and cleanup the errors
 

https://forums.techguy.org/threads/excel-2010-separating-data-from-one-column-to-multiple-columns.1090901/
Relevancy 73.96%

I need a visual basic macro for excel that will do the following From sheet ColumnA Select rows until sheet columnA value does not start with REC as the no of rows is unbalanced sometimes rows sometimes rows sometimes rows etc copy selected rows and transpose to sheet columnA to however many rows were selected Repeat until end for 2002 to in new Visual columns Excel data unbalanced Basic rows sheet using Macro last row My real table has rows and the rows are unbalanced I am attaching a test file Please help me and thank you for your support and time Tech Support Guy System Info Utility Visual Basic Macro for Excel 2002 columns to rows in new sheet using unbalanced data version OS Version Microsoft Windows XP Professional Service Pack bit Processor Pentium R Dual-Core CPU E GHz x Family Model Stepping Processor Count RAM Mb Graphics Card ATI Radeon HD Series Mb Hard Drives F Total - MB Free - MB G Total - MB Free - MB H Total - MB Free - MB Motherboard MICRO-STAR INTERNATIONAL CO LTD G M -L V MS- Antivirus None nbsp

A:Visual Basic Macro for Excel 2002 columns to rows in new sheet using unbalanced data

Can you also attach a second workbook showing how the data should appear after the macro is run?

Regards,
Rollin
 

https://forums.techguy.org/threads/visual-basic-macro-for-excel-2002-columns-to-rows-in-new-sheet-using-unbalanced-data.1080037/
Relevancy 71.81%

Hi I am using a code to compare two spreadsheet One of the function is to copy the modified records in a different worksheet highlighting changes element in red The script works but ONLY when Excel VBA spreadsheet comparing Solved: the cell is modified to quot blank quot no value I get coloured in red the upper cell instead of the correct one Here the script any help Sub GDV Dim WsA As Worksheet WsB As Worksheet WsC As Worksheet WsD As Worksheet WsE As Worksheet Dim rFind As Range c As Range Dim I As Integer ColCnt As Integer Set WsA Worksheets quot OldExport quot Set WsB Worksheets quot NewExport quot Set Solved: Excel VBA comparing spreadsheet WsC Worksheets quot Changes quot Set WsD Worksheets quot PosDeleted quot Set WsE Worksheets quot PosAdded quot ColCnt WsA Cells Columns Count End xlToLeft Column With CreateObject quot Scripting Dictionary quot For Each c In WsA Range quot A quot WsA Range quot A quot amp Rows Count End xlUp If Not exists c Value Then Add c Value False Set rFind WsB Columns Find What c Value LookIn xlValues If Not rFind Is Nothing Then For I To ColCnt If Not c Offset I - WsB Cells rFind Row I Then If Item c Value False Then rFind Resize ColCnt Copy WsC Range quot A quot amp Rows Count End xlUp Offset Item c Value True End If WsC Cells Rows Count I End xlUp Interior ColorIndex End If Next I Else MsgBox c Value amp quot PosID has been canceled quot c Resize ColCnt Copy WsD Range quot A quot amp Rows Count End xlUp Offset End If End If Next c For Each c In WsB Range quot A quot WsB Range quot A quot amp Rows Count End xlUp If Not exists c Value Then MsgBox c Value amp quot PosID has been added quot c Resize ColCnt Copy WsE Range quot A quot amp Rows Count End xlUp Offset End If Next c End With End SubClick to expand nbsp

A:Solved: Excel VBA comparing spreadsheet

to who may be interested
I found a solution (workaround) here:
http://www.excelforum.com/excel-pro...adsheet.html?p=2818323&viewfull=1#post2818323
 

https://forums.techguy.org/threads/solved-excel-vba-comparing-spreadsheet.1056407/
Relevancy 71.81%

I have data that repeats hundreds of times. I am trying to put each string of data on 1 line.

f-name(A2) initial(B2) l-name(C2) ID#(D2) DOB(E2) Street(F2) company(G2)
City(F3) company#(G3)
State,Zip(F4)
Home Phone(F5)
Work Phone(F6)
Email(F7)

After the data is moved to one line I would like to delete the lines that previously housed the information. The company# can be deleted. I have never worked with macros. I would appreciate any help given.
 

A:Solved: move data from rows and columns to other rows and columns

bump
 

https://forums.techguy.org/threads/solved-move-data-from-rows-and-columns-to-other-rows-and-columns.932353/
Relevancy 70.95%

Hello all. I have 2 spreadsheets which contain subscription information for 2 different products costing 21.58 and 5.96. I'm trying to merge this information so that if Mr A in spreadsheet 1 is shown as subscribing to Product B and the same person in spreadsheet 2 is shown as subscribing to Product C, an additional column shows in spreadsheet 1 so that it then appears as: Mr A - 21.58 - 5.96

If not, the columns would show Mr A - 21.58 - 0 (or blank) etc

The code for VLOOKUP is straight-forward but only returns the first row. I need it to reference every row and cross-reference the data.

I'm using Windows 7 and Excel 2010. I've attached a small example though the actual spreadsheet has around 3000 rows. I only need to do this once to get a single file up and running.

Any ideas

Many thanks

Nos
 

A:Solved: Comparing multiple values in excel

Sorry all. Now solved using a simple VLOOKUP and defined names with a fill-down. Doh!
 

https://forums.techguy.org/threads/solved-comparing-multiple-values-in-excel.1069167/
Relevancy 69.66%

Hi There I have run into an issue with excel that s a little beyond my amateur coding skills I think this can be solved with some simple vbscript or nested excel formula All i need to happen is to compare a list of names and one additional value to another list of names and add the missing value Easier if i give an example of data the columns are as follows Column A Column B Column C Column D Name - values Excel Basic multiple Question Solved: Comparing Value Name Value Bob Test Full Bart Test Bill Test Part Bob Test Ren Test Non Bill Test Bart Test Part Ren Test So in column A and B is the reference data and you see Column C and D is where the data needs to be matched copied to The script formula needs to in this case work its way down column C - look up the matching value in column A and then copy whats in column B next to the matching value to column D Example is with the above data it would first hit in column C - Bart Test - it would then lookup cell A for Bart Test - and copy whats in column B beside it which is quot Part quot to blank cell in column D Then it would move on to Bob Test in column C - it would then lookup cell A for Bob Test - and copy whats in column B beside it which is quot Full quot to blank cell in column D I have a massive list of names that gets Solved: Basic Excel Question - Comparing multiple values emailed to in a jumbled order and may grow in cell numbers as well so i cant count on a simple A to Z sort to help out - with additional information that i need to marry up Solved: Basic Excel Question - Comparing multiple values to my existing Solved: Basic Excel Question - Comparing multiple values data I need an easy way to have it find the same name in my data and copy in the additional information provided Any ideas on a formula or vbscript that could do this - i appreciate it in advance Cheers Phenonm nbsp

A:Solved: Basic Excel Question - Comparing multiple values

This is what I think you need (See attached file) Look at the formulas in column D. The first formula can be copied down that column as many times as you require.

HTH
 

https://forums.techguy.org/threads/solved-basic-excel-question-comparing-multiple-values.944651/
Relevancy 69.23%

I'm trying to do a simple 2 column merge in an Excel file. The idea is to put both first and last names (currently in 2 separate columns) into one column. There is more data in the worksheet, address, telelphone etc - in other columns.

When the name columns are selected, then FORMAT CELLS, then ALIGNMENT, MERGE CELLS, it comes back with -

"The selection contains multiple data values. Merging into one cell will keep the upper-left most data only"

There's text only in all the cells in both columns.

When I click on OK - like yea, do it anyway - both first and last name columns are blank - and there is no merged column.

I have also tried to use the CONCATENATE function and it works great for 1 cell at a time, but does not do entire columns...

Is there another step I've missed in this ?

Thanks...
 

https://forums.techguy.org/threads/excel-error-merging-columns-multiple-data-values.1018600/
Relevancy 68.37%

I ve been at this for what seems forever so any help would be greatly appreciated I want to compare data from one sheet to another and for any exceptions non matches I want it to copy and paste the entire row into a rd sheet I ve searched and found various codes about comparing columns but my need seems to be a little more columns VBA Compare data Solved: complex I want it to compare columns on sheet columns A amp B against columns on sheet columns C amp D and it does not what row they are in I also would like the sheet name to be included in the results I ve Solved: VBA Compare data columns attached a sample book with the data Sheet shows what data should generate from this code These would be the results because the names both first and last Solved: VBA Compare data columns do not appear on both sheets I dont have a lot of experience with code so any help would be great Thank you nbsp

Relevancy 67.51%

Hi,

I want to know how i can export the data from Access to excel using Access VBA for the specified sheet using data linkage with access database. Like we used to do it manually in excel as external data from access.

So that the excel size won't be that big and also it saves processing time.
 

Relevancy 67.51%

Hi everyone

I'm a newbie here, so hoping someone can help me!!
I have Names and Mobile Number in Column A. I need to find a way of moving Mobile Numbers into Column B - please tell me there is a simple way in which this can be done.....HELP!
 

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 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%

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 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%

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.
 

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 66.65%

I started out with the two previous posts about macros (post 1, post 2) that move rows into columns, but I'm having a little trouble getting it to work for what I need. First, I'm trying to do a data merge into Word, but in order to get the data merge to work/look the way I want it to, I need the XLS data to be in columns.

I'm attaching an example file that has one worksheet of the sample data (though my "real" data has about 300 rows) and the other worksheet is an example of the outcome I need.

Is there anyway I can do what I need? Exporting into another file or another worksheet within this file would be fine.

Thanks in advance.
 

A:XLS Macro to move data to columns, delete empty rows, delete duplicate columns

https://forums.techguy.org/threads/xls-macro-to-move-data-to-columns-delete-empty-rows-delete-duplicate-columns.1014294/
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%

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 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%

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 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%

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.22%

I am trying to build a spreadsheet that allows me to enter data (steel angle) by individual leg sizes and thicknesses that automatically references the correct weight per foot so I no longer have to look it up in a book. I have loaded the data and built the template, but I cannot get a formula to work that will search my array of data that has repeating data in all the columns, but where all the data in one row has a unique weight. I have tried several commands, and I feel like I need a nested command, but I do not have the knowledge to get it done properly. I have attached the file: Angle Database. Any help will be greatly appreciated.

Regards,

brian
 

A:Solved: Repeating Data in multiple columns for unique result

I used Concatenate and Vlookup to solve the problem. I just needed a week to let my head clear.
 

https://forums.techguy.org/threads/solved-repeating-data-in-multiple-columns-for-unique-result.746951/
Relevancy 66.22%

Hi guys I ve been going through this thread and its been a lot of help I Solved: data Checking seperate finding mismatches in columns and ve now come across a problem that i cant find the solution to and im hoping someone can help me out I have a file that contains two columns of data in MS Excel and one value in the first column corresponds to a value in the second column For example - Column Column A X A X B Y A X B Y What I have to do is find if there are any mismatches in the data for example an X corresponding to B instead of A or vice versa Solved: Checking data in seperate columns and finding mismatches or any other value instead of X and Y in the second column for that matter I would need a message saying there are a particular number of errors and the rows in error should be highlighted I DONT need the corrections just need to see where the mismatches are Im pretty new to Macros and VB so please bear with me but i do understand the basics and ive done some programming before Any help would be greatly appreciated Thanks nbsp

A:Solved: Checking data in seperate columns and finding mismatches

oops.. the X's and Y's are supposed to be in column 2.
That didnt quite show up how i expected it to..
 

https://forums.techguy.org/threads/solved-checking-data-in-seperate-columns-and-finding-mismatches.782032/
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%

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%

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%

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 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 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%

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%

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 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%

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 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.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 62.35%

Hello,

I have 2 price lists from different years. I have copied and pasted the p/n's and costs from both so there is 1 spreadsheet with 4 columns a,b,c,d. Columns A and C are both p/n's from their respected years and columns b and d are costs for each of those years. I Would like to take these 4 columns and create 3. I want 1 column with all the p/ns so I would need to match and remove duplicates and then I would like to keep both of the b and d columns but have them match up properly to column a once a and c and joined and duplicates removed.

Is this possible, sorry if this is just jumbled together.
 

Relevancy 61.92%

Real dummy here using Access. I have two tables containing 80,000 names. These tables are going to change weekly. What I need is a query that will compare new user in table 2 to the ones in table 1. Then I need a query that will show the users that are not in table 2 that were in table 1.Hope this makes sense.
 

Relevancy 61.92%

Hello I have two problems I have a lot of scanning data all date and time stamped All the scans show different status of shipped packages all shipments have unique ID but there are multiple scans data export from macro to second Solved: excel ACCESS: and Show latest data on route for all Solved: ACCESS: Show second latest data and export data to excel from macro of them to track the packages I want to find all the packages for which there was quot misdirected quot scan then for all of them show the scan before So the end result would be all the scans that show for each package where it was misdirected the terminal of the scan before the misdirect scan I want to automate this run queries every two hours between am and pm copy and paste all results into Excel to specified areas e g first query results to A second to A third to A etc or onto different tabs save as csv to a specific folder then send it as attachment to a given e-mail address Even partial solution can be good I only know macros somewhat not as much VBA so I tried that with the TransferSpreadsheet command but can t get it work Any help is greatly appreciated nbsp

A:Solved: ACCESS: Show second latest data and export data to excel from macro

https://forums.techguy.org/threads/solved-access-show-second-latest-data-and-export-data-to-excel-from-macro.942280/
Relevancy 61.92%

Excel 2003 SP3
Could anybody suggest a way, using whatever method you prefer to copy existing data to another tab, but have the data go transparent by 50%(or thereabouts, so you can just see it), but keep the headings normal font.
Thanks
 

A:Solved: Excel 2003 help to copy data to new tab and make data transparent

https://forums.techguy.org/threads/solved-excel-2003-help-to-copy-data-to-new-tab-and-make-data-transparent.807436/
Relevancy 61.92%

When i export my inventory from my DB into an excel file my trailer brands are listed as they are in my DB of course But when i bulk upload them with XML feed to trailer inventory sites HTW com amp HTT com for our example here My inventory is listed on their site but it s not searchable because the brand search is a Replace with similar - sample data required Solved: Formula? Excel my data or -Macro drop down Solved: Excel -Macro or Formula? Replace my data with similar required data - sample menu on these sites Say i goto HTW com and do a search for Blue Ribbon trailers none of my blue ribbon trailers show up because all of Solved: Excel -Macro or Formula? Replace my data with similar required data - sample mine are listed as BLUE RIBBON TRAILERS LTD and the site is searching for Blue Ribbon and although they are the same trailer brand HTW com does not see them What i m looking for is maybe a Macro or even formula that once i tell it what site i m working on will go through my list and replace all my spellings with the proper ones for that site Attached is an XLS file with columns the first is my list as is from my DB the other columns are the proper spelling for each corresponding site Excel s find and replace feature is a VERY crude fix to this but since it s so time consuming it s NOT a viable solution Any takers Slurpee Zack Anyone nbsp

A:Solved: Excel -Macro or Formula? Replace my data with similar required data - sample

for the record, a complete solution would be GREAT, but not necessary...
I just need someone to point me in the right direction and maybe a small working sample of like 5 brands and i'll expand the list from there...

cheers
 

https://forums.techguy.org/threads/solved-excel-macro-or-formula-replace-my-data-with-similar-required-data-sample.974275/
Relevancy 61.49%

Hi Guys,

I have an Excel 2007 Workbook with two Sheets.

Sheet1 is Info pulled from a SQL DB Table. It shows Residential and Postal codes for suburbs. Both residential and postal codes appear in one column.

Sheet2 is info pulled from the Post Office Website. It shows Residential and postal codes. However, it displays them in two seperate columns.

Therefore, Sheet1
A B C
Suburb City code
---------- ------ -------

Sheet2 :
A B C D
Suburb City Residentialcode postal
---------- ----- ----------------------- ---------
I need to compare these data as the data from the SQL DB(Sheet1) may be outdated. Sheet2 is from the post office as

Is there anyway to compare them?
 

Relevancy 61.49%

Hi, I have 2 lists of numbers in excel, both lists are about 40000 long each. I need to see how many records match and see what ones are unmatched?

Does anyone know of an easy way to do this? Have tried 'IF' but could only make it check individual cells rather than the whole list?

Cheers.

A:Comparing lists in excel?

I think you might find Steps: 4 & 5 useful in the following article - Use Excel to compare two lists of data - Excel - Microsoft Office

http://www.sevenforums.com/microsoft-office/135684-comparing-lists-excel.html
Relevancy 61.49%

Hi,

This may be a very elementary question. I am not a super sophisticated excel user, but was wondering if there is a way in Excel to compare the formulas (instead of the results) across several worksheets in a workbook. For example, I need to know if the formula in cell A1 on every worksheet is the same.

Optimally, if one does not equal the test formula, I would like to have the tab name returned.

Thanks in advance,
DV
 

Relevancy 61.06%

Hello again,

I have a word doc that has a form in it. The form may have any number of fields (boxes) to type text answers into, or be a drop down list to select an answer from. I need an excel macro that extracts all data from the form, but with every five fields starting a new row in excel. So all data from the form will appear within 5 columns in an excel spreadsheet.

field 1 field 2 field 3 field 4 field 5
field 6 field 7 field 8 field 9 field 10
etc

Is that possible? I have had no luck to do it myself.

Sample form attached, thank you
____________________________
 

Relevancy 61.06%

How do you compare 2 Excel workbooks,not sheets, at the same time.in order to compare side by side the data contained in each..

Thank you for your guidance

roy[/SIZE]
 

A:Viewing/Comparing 2 Excel workbooks

Open both documents in the same instance of Excel and then click Window/compare side by side.
 

https://forums.techguy.org/threads/viewing-comparing-2-excel-workbooks.839685/
Relevancy 61.06%

Hello,

I am new to macros. I want to compare two excel spreadsheets. Specifically, Book1 is the source file with upto 4 columns populated. Book2 has only one column populated with data that might be contained in any of the 4 columns of Book1. What I am looking for this, a macro to compare each cell of Book2 with the contents of Book1 and if there is a match, to highlight the particular cell in Book1 and in Book2.

I would appreciate any help.

Thank you in advance for your help.
 

Relevancy 61.06%

HELP

I need to compare 2 different Excel spreadsheets (each spreadsheet has at least one column of data which is the same) When I get a match I want to be able to then say if a match occurs then show the data from another cell. The main priority is how to compare the 2 spreadsheets. I think it is something to do with VLOOKUP but I am a complete novice so please help if you can.
 

A:Excel - comparing 2 separate worksheets

It's easy to do if the rows and column numbers are the same but once they are throughout the column with the same vale it gets weird. Try a pivot table to do it. I think you are getting into the realm of a database with what you are trying to do. Try a simple databse and import you data into different tables for each spreadsheet and run a query on the two fields that contain the same data.
 

https://forums.techguy.org/threads/excel-comparing-2-separate-worksheets.49484/
Relevancy 61.06%

Hello!
I want to compare two cells in excel. Each cell is multi-valued. i want to compare both cells and place common number and uncommon number in two different cells.
i.e.
Col A Col B Col C Col D
1,2,5,7 4,5,7,2
2,3,1,8 3,5,9,1
3,5,9,6 4,9,8,6

So i want to compare each cell in A & B and put common numbers in C and different numbers in D.
Can i do it with formula? bcz i have a very large list..
please help me.
Thanks
 

A:comparing multivalued excel cells

Welcome to TSG!

I'd click on "Report" below your first post here and request thread moved to "Business Applications" forum.
 

https://forums.techguy.org/threads/comparing-multivalued-excel-cells.857786/
Relevancy 61.06%

Good day -

I need to compare cells in the same column in a BIG Excel 2007 file. When a change in the values is found, insert a row. Example:

A801
A801
A801
999B
999B
80C5
80C5

Using this example, a blank row would be added between the last A801 entry and the first 999B entry. And another blank row would be entered between the last 999B entry and the first 80C5 entry. I.e.,

A801
A801
A801

999B
999B

80C5
80C5

As you can tell from my example, the cells to be compared are alpha/numeric. Ideas?

Thank you in advance. abgbpb
 

Relevancy 60.63%

Please help ,

I have one sheet with headings,with 50 more sheets which include data,in data we have one emp code which is unique and more data for that emp.,format in all the sheets is same except the summary sheet(main sheet),what i want when i enter the Emp code in suumary sheet,the excel automatically search the data from subsquent sheet (basis emp code)and enter the data in next columns against emp code in summary sheet.

Regds
Mayank s
+919376914028,
 

Relevancy 60.2%

I need to take information from a separate excel workbook and add it to the information being output to the four note pad documents The code I have right now is Private Sub BigButtonOfDoing for comparing footer header excel in Importing and and Click Dim target As Worksheet For Each target In Worksheets SheetStorage target Next End Sub Public Sub SheetStorage target As Worksheet Dim iFileForSheet As Integer LR As Long i As Long Dim strFile As String Dim strRec As String Dim qoutes As String Dim comma As String strFile quot C Documents and Settings nicolas amp amp amp amp amp amp amp amp amp amp amp amp amp DDLGanerator output quot amp target Range quot J quot Value amp quot txt quot LR target Range quot C quot amp Rows Count End xlUp Row iFileForSheet FreeFile Open strFile For Output As iFileForSheet For i To LR Print iFileForSheet target Range quot C quot amp i Value Spc target Range quot D quot amp i Value Spc target Range quot G quot amp i Value Spc target Range quot J quot amp Importing and comparing for header and footer in excel i Value Next i Close iFileForSheet End Sub There is the name of the document in cell j The information shown below is from a separate workbook that needs to be opened compared against then read in as the table name as the header and the tablespace initial and next as the footer TableName TableSpace Initial Next PS NFS JK MAIN NFSPRJ M M PS NFS JK HITO NFSPRJ K K PS NFS JK TAIJIN NFSPRJ M M PS NFS HOSPITAL MS NFSPRJ K K PS NFS JK TAIBUTSU NFSPRJ K K PS NFS JK SHARYO NFSPRJ K K PS NFS IMAGE PATH NFSPRJ K K amp amp amp amp amp amp amp amp tablename is the same as in cell j in the main workbook all the information shown here needs to be displayed like so CREATE TABLE PS NFS HOSPITAL MS quot information already inputted by above code quot TABLESPACE NFSPRJ STORAGE INITIAL K NEXT K thanks nbsp

https://forums.techguy.org/threads/importing-and-comparing-for-header-and-footer-in-excel.834051/
Relevancy 60.2%

Hey guys, I have a spredsheet with 3 seperate worksheets. One has a huge list of properties in a column, and the second worksheet has another huge list of properties in a column. I need to know how to compare column 1 (on worksheet 1) with column 2 (on worksheet 2) and then return values that have close or exact match.

E.g

Table 1 Table 2

Sky Hotel Moon Hotel
Golden palace hotel Golden palace hotel
Atrium Hotel Atrium Hotel
Beach Hotel Beach hotel

I need these values to be compared, and ones that match/or do not match to be listed on worksheet 3. E.G

Worksheet3:

Table 1 Table 2
Golden Palace Golden Palace
Atrium Hotel Atrium Hotel
Beach Hotel Beach Hotel

(notice how sky hotel has not been displayed here)

If Vlookup or something similar is the formulae to use, could you tell me how to use it, as I've tried but to no result.

Thanks guys!
 

A:Excel 2007 - comparing values in one worksheet to another

The simple answer is arrange the tables next to each other (1 in column A, 2 in column B), then use:

=A1=B1

in column C to return TRUE or FALSE.

However, I suspect it's more complicated than you're suggesting.
 

https://forums.techguy.org/threads/excel-2007-comparing-values-in-one-worksheet-to-another.697896/
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%

Hello,
I'm trying to create a spreadsheet that will inform me about whether students have correctly entered formulas in another worksheet, or if they've simply put in the resulting number. I need to create an if statement that would test whether the formula is entered in the cell correctly, not whether the result of the formula equals a particular number. Don't see any way of doing this. Any help would be appreciated.
Thanks.
 

Relevancy 58.05%

Alright so I have 2 workbooks lets say "workbooka" and "workbookb" they both contain the same column header "asset #". Workbooka has a list with no duplicates and is listed as column D. While Workbookb has a couple duplicates and is in column F. I wanted to be able to pull the information from workbookb into workbooka for only the "asset #" that match. Because of the duplicates however I have been running into a problem. Looking for input that does not involve a macros or add-in.

Thank you
AJ
 

https://forums.techguy.org/threads/match-columns-and-data.1169717/
Relevancy 58.05%

Hi,i found this question and seems near to my problem, but I totally dont know how to revise the code."Excel: Moving Column Data Into New Rows??"I have this data:UniqueID Company 1FullName 1Designation 1CountryCode 1Phone 1Email 2FullName 2Designation 2CountryCode 2Phone 2EmailR123456 Company1 Chris Reeves +65 90221111 [email protected] R234567 Company2 Sam Lim Sole Proprietor +65 9851234 [email protected] Samboy Lim Account +65 94890987 [email protected] Company3 Jose Accounts Department +65 67672345 [email protected] and I need the above data to be like this:UniqueID Company 1FullName 1Designation 1CountryCode 1Phone 1EmailR123456 Company1 Chris Reeves 65 90221111 [email protected] Company2 Sam Lim Sole Proprietor 65 9851234 [email protected] Company2 Samboy Lim Account 65 94890987 [email protected] Company3 Jose Accounts Department 65 67672345 [email protected] help.Thanksedited by moderator: Mask email addresses

A:Moving columns data into new row

I have edited your post to mask anything that looks like an valid email address. We do not want this forum to become a place where email addresses can be harvested. Once the bad guys start hanging around it's really hard to get rid of them.I can not determine the layout of your input or output data.Please click on the following line and read the instructions on how to post example data in this forum.Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

http://www.computing.net/answers/office/moving-columns-data-into-new-row/20216.html
Relevancy 58.05%

I have an entire column of data that I need in one cell. When combined I need each piece of data to be surrounded by " " and a , between each one.

151
183
2001

results = "151","183","2001"
 

A:Solved: Excel Column of data place in one cell with "data", "data" results

ASAP's "Merge row data" ("Columns and rows" category) will do 99% of the work for you.

http://www.asap-utilities.com/

(edit: "entire column" -- do you mean full from top to bottom? )
 

https://forums.techguy.org/threads/solved-excel-column-of-data-place-in-one-cell-with-data-data-results.975601/
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