Windows Support Forum

Solved: Problem with CountIF comparing columns of names

Q: Solved: Problem with CountIF comparing columns of names

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

Relevancy 100%
Preferred Solution: Solved: Problem with CountIF comparing columns of names

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

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

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

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

Is there an easy way to only count instances where two columns have two different values?

Example: I want to count instances where Column A = "Test" AND Column B = "Evaluate". If either column is not equal to that value, it doesn't get counted, even if the other column is correct.
 

Relevancy 73.53%

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

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

Hi,

i am trying to see how many times each persons name appears in a list (i need to see the unique records so that i can put them into a list of managers/advisors)

i have a list of 242 names in Column M, and a managers name in column N.

I have filtered out the list (using advanced filter and copy unique records only) into Column P and Q and then used the following formula to count how many times each persons name appears:

=COUNTIF($M$4:$M$465,R4)

Then to check it has worked properly i used the SUM function to tally the numbers next to the names, however for some reason the tally adds up to 248... 6 more than there are names in the list!

i have clearly gone wrong somewhere but i cant figure it out

any help is appreciated (including any easier ways to do this if any)

Thanks

Carpy
 

A:Solved: Excel 2007 Countif problem

What you have to keep in mind is the fact that if you use Countif as you have doen, every you also count double

Jim 3
Albert 2
John 1
Jim 3
Jim 3
Albert 2

So if you tally this you get 13 instead of 6 becasue Jim is counted 3 times and Albert 2

You must only create a list of unique names for one column at a time
The combination you have of Advisor and manager is the problem.

Create One column with Unique advisors and one with unique managers indenpendant of each other.
 

https://forums.techguy.org/threads/solved-excel-2007-countif-problem.1008258/
Relevancy 64.93%

Hi

Attached is a spreadsheet with a list of names and whether or not a project they are working on is completed or in progress.
I know how to count the total number of projects that an individual is working on, and I know how to count the total number of projects that are completed or in progress. My question is how do I combine those two things? i.e. I want to be able to count the number of projects worked on by each individual that are completed (in column H of the attached spreadsheet).

Thanks for your help.
 

A:Solved: Excel 2003 COUNTIF problem

Try with SUMPRODUCT:

=SUMPRODUCT(((A2:A10)=G2)*((B2:B10)="Completed"))

Jimmy
 

https://forums.techguy.org/threads/solved-excel-2003-countif-problem.951135/
Relevancy 63.64%

Hello all There s a ghost in the machine I m running Excel on Windows XP In using the COUNTIF funcition It will count certain rows of data but not others Check this out In example below the quot count quot column has formulas where I drag them down so C COUNTIF A A B C COUNTIF A A B C COUNTIF A A B etc In column quot B quot I manually typed quot quot quot quot and quot quot and used auto-fill for the rest all! working Problem: data some - Excel not not COUNTIF Solved: counting but as it goes on and on up Solved: Excel Problem: COUNTIF not working - counting some data but not all! to A Solved: Excel Problem: COUNTIF not working - counting some data but not all! B C data cond count Notice in cell C that nothing shows up Even though there is a value in column A of quot quot shows up and so does So why not Here s the kicker - if I go into cell B and MANUALLY TYPE IN quot quot then it gets counted in C Problem is the data column A is cells long and column B is columns I can t manually type in each time condition times in column B I have checked the format of all cells and they are all set to the same format of Time What am I missing This is such a powerful function but why is it not working for me Any help or suggestions are severely appreciated Much respect Kiwi Berg nbsp

A:Solved: Excel Problem: COUNTIF not working - counting some data but not all!

https://forums.techguy.org/threads/solved-excel-problem-countif-not-working-counting-some-data-but-not-all.782012/
Relevancy 60.63%

I have an Access 2003 table (Table1) with four fields:
Amount (number, single format, 3 decimal places)
Add (number, single format, 3 decimal places)
Calc (number, single format, 3 decimal places)
Test (number, single format, 3 decimal places)

There is one record:
Amount=40
Add=1.021
Calc=40.84
Test=

The first query updates the "Test" field by [Amount]*[Add] with the result that the test field now contains the value 40.84

Then I run a query to find records where [Test]<>[Calc] and it returns the record even though the values in the two fields are equal.

Help! Please???
 

A:Solved: problem with access 2003 calculation comparing values

What does the record say when you run the 2nd query?

When I run the second query, I get a 0 for the first record (using the info you listed). I added in a few records of my own and got -1. If I'm not mistaken the 0 means False/No and the -1 means True/Yes. So the 0 means that no records match [Test]<>[Calc] and the -1 means that records match [Test]<>[Calc].

Either way please explain more so I can get a better handle on what you are looking for.

Best,
Zhouma
 

https://forums.techguy.org/threads/solved-problem-with-access-2003-calculation-comparing-values.864815/
Relevancy 59.77%

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

Hi there I am pulling together some reporting for work and - COUNTIF/S Excel problem having trouble with the COUNTIF and COUNTIFS functions My team give me a report each week which I update to a master file I do a summary which will tell me how many appointments have been attended completed in any given week Basically I have broken the year up into weeks and I am trying to Excel - COUNTIF/S problem track the number of appointments completed in each week I listed each day of the year in date form and number form just to double check I am on track I then ran a COUNTIFS function COUNTIFS AA AA quot lt AB quot AA AA quot gt AB quot The cells AB and AB are the cells containing the dates either starting or ending the week I am trying to track AA AA is the column of the dates the appointments were completed Whenever I go to the Excel help sections it indicates the formula is correct but they keep returning an answer of quot quot which is wrong I am sure there is a simple answer but I have not more hair to pull out so would appreciate any assistance Thanks Bernie nbsp

Relevancy 55.47%

I m writing some code in excel s vba to put a formula into a cell Here s a short snippet Race ActiveCell Offset Select ActiveCell Value quot White quot ActiveCell Offset Select ActiveCell FormulaR C quot COUNTIF R - C R - quot amp NumRows amp quot C quot Age ActiveCell Offset - Select ActiveCell Value quot Over quot ActiveCell Offset Select ActiveCell FormulaR C quot COUNTIF R - C R quot amp -NumRows - amp quot C quot lt quot quot The code I wrote to count the number of occurences of a single number a column works fine the first section However the next part gives me a Compile Error stating quot Expected end of statement quot and it highlights quot quot My format looks the same as every website I ve looked at I tried replacing the last comma with a semicolon and taking out the brackets around the variable I have no clue what s wrong with this code I would appreciate any ideas Thanks problem excel :( COUNTIF vb -mati nbsp

A:excel vb COUNTIF problem :(

ActiveCell.FormulaR1C1 = "=COUNTIF(R[-3]C:R[" & -NumRows - 2 & "]C, ""<40"")"

i.e. double-quotes.

Rgds,
Andy
 

https://forums.techguy.org/threads/excel-vb-countif-problem.244284/
Relevancy 55.47%

i want to use countif formula in excel but but count if works on single criteria but i want to check multiple criterias is there any formula for this
 

A:Countif formula problem

Summing And Counting Using Multiple Criteria
 

https://forums.techguy.org/threads/countif-formula-problem.834152/
Relevancy 54.61%

I upgraded to XP and I'm much happier
but I'm having a few problems.
If I log out of a screen name it won't let me log back in to any of them. I end up having to restart. I had to delete the other two SN and change the setting so windows logs into the primary screen name when it starts up. Is there something wrong?

Ray
 

https://forums.techguy.org/threads/solved-problem-with-user-names-in-xp.378447/
Relevancy 54.18%

I have a set of 0's and 1's here. I need to count the total of times that a 1 appears four or more consecutive times and place a 1 in the adjacent column next to the set.

I prey to god that I explained myself clearly.

In my uploaded sheet, I made an example by placing a 1 in b809, and b1172.

Thanks in advance
 

Relevancy 54.18%

on a worksheet i have the following countif(e7,ak3)

e7 is the cell where different figures are entered, ak3 is the cell where i can enter any number that i want counted

when the number ie 100 is entered this is recorded in cell h17 as 1, but once a different number is entered in e7 cell h17 reverts to zero,
how can i get cell h17 to continue counting when the number 100 is entered.
 

Relevancy 54.18%

I have a calculation that is working perfectly for the application that I need,however data from another sheet will populate the individual cells. When I link them the #DIV/0! error activates the cell and the cacluation includes that cell which I dont want to do.

The calculation is to show a running score during a 9 week course on a weekly attenance rating

=countif(b16:k16,"y")/counta(B16:K16)

ive tried

=iferror(countif(b16:k16,"y"))/iferror(counta(B16:K16))

and

=IFERROR(COUNTIF(B16:K16,"Y"),"<>#DIV/0!")/COUNTA(B16:K16,"<>#DIV/0!")

but it keeps including the other active cells. Any suggestions would be helpful
 

A:Solved: countif/counta

If you think about it the problem occurs when you haven't got any "Y" responses, so I'd rule them out first ...

= if(countif(b16:k16,"y")=0,"",countif(b16:k16,"y")/counta(b16:k16))
 

https://forums.techguy.org/threads/solved-countif-counta.1150124/
Relevancy 54.18%

Okay - here we go again! I guess I closed out the old thread too soon on this one.

Here is what I am trying to figure out:
IF Sheet 3 - C11 = "1", then Sheet 3-H11 = the number of x's from Sheet 2-D17 to D28
If Sheet 3 - C11 = "2", then Sheet 3-H11 = the number of x's from Sheet 2 - D17 to D28

And so on across & down the grid on sheet 3.

Is this even possible??
 

Relevancy 54.18%

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

I want to use the countif formula to count firstly the number of people who haven't closed off a complaint (in total), I then want to break it down to count the number of complaints each particular person hasn't closed.

=COUNTIF(COMPLAINTS!$AB$10:$AB$837,"NO") - counts the total number of people who haven't closed off a complaint. This formula works

I have added this - AND(COMPLAINTS!$V10:$V837,M7). as my second condition which aims to break it down into the specific person who has closed a complaint. M7 refers to the name of a person within that cell.
Full formula - not working
=COUNTIF(COMPLAINTS!$AB$10:$AB$837,"NO")AND(COMPLAINTS!$V10:$V837,M7)
 

Relevancy 53.75%

Have an Access 2000 report in which I would like to get a count of each different value in a single-character text field. The file can have the values A, B, E, and M. So in the report footer, I want four fields that count the A's, the B's, the E's and the M's separately. In other words, the same thing CountIf does in Excel. I can't find such a function in Access. Is there such a function?
 

Relevancy 53.75%

I have no little to no experience with excel Macros or VBA, but I would like to create a macro to count a string of text on every page of my workbook.

Basically, I have 10 separate sheets in my workbook with a list of ID#s all in column B.
I want to create a macro that will check column B for a specified ID# in all 10 worksheets and tell me how many times it showed up in the entire workbook.

Is this possible and if so how? (Please remember I have little to no experience creating macros so very detailed explanation is required).

Thank you
Amber
 

Relevancy 53.75%

I have a few cells that have numbers, derived from the countif function.

But I want to add these values up, instead of getting the numerical value I just get the formula appearing in the cell.

E.g.

Let's say I have a countif function in cells A1, A2 and A3. Each of them come to 2.

In A4 I type in =sum(A1:A3), but instead of "6" appearing I just get the formula. Tried formatting the cell but it made no difference
 

Relevancy 53.32%

I have done my best to show what I mean by attaching screen shots from my Asus computer. The Toshiba has only the "1850house" name in its networking "files."

Strangely, both computers can access one another, with one exception where I am being denied permission to access the Toshiba's "C" drive from the Asus. [See last screen shot.] I can, however, access the Asus' "C" drive from the Toshiba.

I set the permissions for accessing the Toshiba's "C" drive for "everyone." [I am the only person who has access to the computers and they are password protected.]

{redoak}
 

A:Solved: Network apparently has two names in different places, plus a 2nd problem

https://forums.techguy.org/threads/solved-network-apparently-has-two-names-in-different-places-plus-a-2nd-problem.928175/
Relevancy 53.32%

Looking for With Solved: Leading Zeros Names In Problem File assistance again Thought I would put together a small script to let me allocate random names to files and at the same time add a Prefix or a Suffix as required However the problem I ran into Solved: Problem With Leading Zeros In File Names was when I wanted the suffix to include leading zeros namely if the file name was to end txt I wanted to have txt Providing in the suffix data input box did not work despite showing as txt on screen The resultant file came out as txt Using a function seemed to work on a single file until I remembered that a function doesn t work in a loop Can any of you guys out there assist and point me in the right direction I ve added my script below It does what I want apart from adding the leading zeros but it s a bit rickety The files I was testing it on are named Library txt Library txt Library txt Thank you Code Option Explicit 'Define vars Dim fso f intMax iLoop k intValue strChar strName intNum Dim File strPrefix strSuffix Tally x Pad n Set fso CreateObject quot Scripting FileSystemObject quot ' Characters available for random choice Const Chars quot abcdefghijklmnopqrstuvwxyz quot ' Specify length of names intMax 'Input File Prefix strPrefix InputBox chr amp chr amp chr amp chr amp quot Enter Prefix quot quot Data Input quot 'Check point wscript echo quot Prefix Entered Is quot amp strPrefix 'Input File Suffix strSuffix InputBox chr amp chr amp chr amp chr amp quot Enter Suffix quot quot Data Input quot 'Checkpoint wscript echo quot Suffix Entered Is quot amp strSuffix Tally quot - quot Set f fso GetFolder quot F Test Test quot For Each file In f Files if instr file name quot Library quot gt then tally Tally Randomize strName quot quot For k To intMax ' Retrieve random character between and intValue Fix Rnd ' Convert to allowed character strChar Mid Chars intValue ' Build the name strName strName amp strChar Next Wscript Echo strName 'Checkpoint 'wscript echo len strName 'Checkpoint 'wscript echo len strSuffix x quot quot 'Pad for leading zeros pad -len strSuffix 'Checkpoint 'wscript echo pad ' 'Build leading zeros for n to pad strSuffix replace strSuffix strSuffix x amp strSuffix next 'Checkpoint 'wscript echo quot Screen Suffix quot amp strSuffix fso MoveFile file Name Replace file Name file name strPrefix amp quot quot amp strName amp quot quot amp strSuffix Tally amp quot txt quot end if 'Checkpoint 'wscript echo quot Suffix quot amp len strSuffix Next Set f Nothing Set fso Nothing Wscript Echo quot File Names Allocated quot Wscript Quit nbsp

A:Solved: Problem With Leading Zeros In File Names

Hi there,
Looking at your code I get lost along the way, but if the filename is to be a number then you have to make sure you also allocate is as a string.
The way I do it when I'm coding with vba is using the right() function. I came accross this when looking for some code

Let's say:

x = 3
and my filename in this case will always be 8 characters long then I do it as follows:

fname = right("00000000" & x, 8)

The answer is 00000008

if x = 42

the result is 00000042

Maybe this will help to point you in th the right way.
 

https://forums.techguy.org/threads/solved-problem-with-leading-zeros-in-file-names.1094648/
Relevancy 53.32%

Does anyone know a way to manipulate the countif formula to count how many cells are "green" or "red" (with varying text in each cell), rather than the value of the cells?

Can this be done in VB?
 

Relevancy 53.32%

I am trying to count the number of times a particular word appears in column K, when I use the COUNTIF command =Countif(K9:K80,"Inhouse") I am not getting any values returned even though the word Inhouse appears in this range.

When I try the same command on a different column =Countif(H9:H90,"PP NBE") it works fine.

I have confirmed that the data type is text for the range in both cases. I even tried copying column K into column H and that didn't work.

Is there a secret handshake I'm missing?

Thanks!
 

A:Solved: Excel COUNTIF - works in one column, not another

Turns out there are extra spaces after the words in column K so I have to replace the content with the same content but without spaces.

Does anyone know a less messy way around this? Can I use a wildcard after "Inhouse*" or something?

thanks!
 

https://forums.techguy.org/threads/solved-excel-countif-works-in-one-column-not-another.1064200/
Relevancy 53.32%

Hi there fellow Excel users here is my question I have researched a number of GREAT Excel sites but my issue goes a little beyond what I am finding and some of the answers I am seeing go a little beyond me so I thought this Average/Countif/Div/0 Solved: Excel Question might be the place to go In am trying to get rid of Div errors and keep finding a neat little macro or subroutine you may be aware of it but I do not know how to actually put this sub into my spreadsheet Not even sure if I want to go the macro route so here is my issue I am using a series of data that is not congruent and using the COUNTIF function that is working fine but I am averaging a series of averages using weekly averages of some tracking numbers and then making a monthly average from those or averages Some weeks there are all zeros which gives me properly the div error well if any week average has the div error I then get that error for my monthly average of the averages If I could just get Solved: Excel Average/Countif/Div/0 Question my weekly averages that equal div to show up as a blank or better yet ZERO then I think my monthly average of averages will work out OK I am open to any and all suggestions Thank you all very much for reviewing this post and possible helping out Don in Tucson AizA nbsp

Relevancy 53.32%

Hello: I am using a "countif" formula & it works great for 1 criteria - but I want a count count only if 2 criteria are met (in 2 different columns) - the formula I am using is:

=COUNTIF($A$18:$A$99,"NSY")+COUNTIF($D$18:$D$99,"01")

It doesn't seem to work correctly - what am I doing wrong, any suggestions?

Also, I have an excel file saved on a shared drive - which includes drop-down menus. When my coworker opened it on her computer - the dropdown menus were not there. How do I ensure the formats/dropdown menus appear no matter where the file is opened?
 

Relevancy 52.46%

I'm new to Excel and hope you can help in finding a solution to my problem. Basically, I have a worksheet with a list of people's names in column A, from A1 to A50, with this list being the names of the people working on 50 different projects. I have a second worksheet with another list of names, also in column A from A1 to A100. This list is the names of people who have achieved a certain qualification.

I know some of the names from the first tab appear in the list of names in the second tab, and I'm wanting to count how many of the projects are being worked on by somebody who has the qualification. I assume I'd need to use the COUNTIF function but haven't been successful in getting anything to work. Any suggestions for a formula will be gratefully received.

Thanks
 

Relevancy 52.46%

I know there is a lot of info out there about countif and drop down lists but for some reason I just can't find an exact match to my problem. I have a column of values (abnormal, normal, mutated, etc.) with a filter on it - so I can see only those rows with that value. I want to make a dynamic chart with that number of values out of the total number (11,942). So what I did was make a separate column called graph data and just put the number 1 all the way down, and then did a countif to count how many times "1" appeared in the list - but the problem is, the countif number doesn't change when I change my filters. Thanks in advance, any help would be greatly appreciated!
 

Relevancy 52.46%

Hi! I tried using Countif but without any luck and am not sure what will actually. I need Excel to look up data in Column E, count any instances of "Tree" and then look in Columns K to M any count instances of "c" where E = "Tree". For example:

Column E
Tree
Plant
Flower
Tree
Tree

Column K
c
c
b
b
g

Column L
b
b
g
b
g

Column M
b
b
c
b
c

I would be looking for Excel to return "2" as there are two Trees in Column E that have a 'value' of c in columns K to M. Am I missing an obvious solution here?

Many thanks as always for any advice!
 

A:Solved: Excel 2007: Can I use multiple criteria for Countif?

this should work
=SUMPRODUCT(($E$1:$E$100="tree")*($K$1:$O$100="c"))
OR

=COUNT(IF((E1:E100="tree")*(K1:O100="c"),1))
as an array formula - after adding to the formula bar - use contol+shift+enter to change to an array formula } will appear around the formula

see attached spreadsheet
with both formulas in D14 and D16

EDIT - while working on the solution, you edited the post - so my data does not match yours - the answers the same though
 

https://forums.techguy.org/threads/solved-excel-2007-can-i-use-multiple-criteria-for-countif.1085473/
Relevancy 52.46%

Basicly all I want to do is get a count of entries in a list, if the date in the cell is less than today. The formula I have been trying to use is =COUNTIF(O73,(O73<TODAY())) but its not working so I am obviously doing something wrong can anybody help ?

I have a workround by using a hidden column and a few other arguments etc. but its cumbersome I like the elegance of a simple formula and it should be easy !
 

A:Solved: Excel 2003 - COUNTIF() Date Comparison

The syntax for countif is =Countif(range,test)

Range should be a range of cells, your formula will at most return 1 if O73 < today.
If you want to count all the ones between O1 and O100 you'd put O1:O100 in the place of range.

Test works on the cell being inspected automatically so you don't need to repeat the cell. What you do need is quote marks (not parentheses) around the criteria. For example to count the numbers in O1 to O100 whose value is less than 4 you'd write =countif(O1:O100,"<4")

Because Today() is itself a function it doesn't go within the quotes. It is joined to the less than sign by an ampersand. So in your particular case you'd want

=COUNTIF(O1:O100,"<"&TODAY())
 

https://forums.techguy.org/threads/solved-excel-2003-countif-date-comparison.977055/
Relevancy 52.03%

Does the COUNTIF function not work on cells that have drop down lists? I haven't found any notations anywhere to say pro or con. I need to do a count of the cells that have either of 2 entries out of the 10 available in the list and:
=COUNTIF(Sheet1!H9:H200, "Statement")
is not working, though according to everything I can find online it should. Any ideas would be great. Thanks
 

A:Solved: COUNTIF function not working with Cells that have Drop Down Lists

Read here:
http://www.microsoft.com/office/com...133C&mid=91806D61-5E51-41E7-A12B-CB4E0ADB133C
Offhand, I think it is the same as in that thread - "You can't using data>validation, you can if you use a combobox from the control toolbox."
 

https://forums.techguy.org/threads/solved-countif-function-not-working-with-cells-that-have-drop-down-lists.826812/
Relevancy 51.17%

Okay new problem btw thanks everyone for the help thus far My program does not seem to be comparing two -bit unsigned long long numbers properly Here is a code snippet and its resulting printout Code printf quot Time llu cycles n quot t printf quot Time llu cycles n quot t printf quot Time Solved: Comparing Numbers - Time llu cycles n quot time passed printf quot Minimum exptected time u cycles n n quot expected time if time passed lt expected time Failed else Passed Code Solved: Comparing Numbers Time cycles Solved: Comparing Numbers Time cycles Time - Time cycles Minimum exptected time cycles FAILED The number in the printout look good i e they are in the range I expect to see However the compare in the above if statement did not work right As you can see the time passed is clearly more than the minimum expected time so it should have passed Does anyone know what is going on here Is there some kind of magic code I need to use to make this work with -bit numbers Thanks nbsp

Relevancy 51.17%

Would this: AMD E Series Dual Core E 450 Processor 1.65GHz
be an improvement over an intl pentimento 1.6 GHz?
Thanks!
 

https://forums.techguy.org/threads/solved-comparing-processors.1062994/
Relevancy 51.17%

I'm looking at 2 different processors but don't know which is better. Can anyone help?

The first is "Pentium Dual Core E5300 with VT/2.60GHz,2M,800FSB"

The other is "Intel® CoreT2 Duo Processor E6600 (2.40 GHz, 4M Cache, 1066 MHz FSB)"

Not sure how much, if any, the FSB and Cache offset the .2 GHz difference.

 

Relevancy 50.31%

Hi All,

I've been searching for a Windows equivalent to the unix 'diff' program that allows you to compare two files since the late 90's. I found 'diff' extremely usefull in programming, so I was always curious if there was an equivalent program that would allow me to edit my term papers, proposals, presentations, etc. using some editor other than vi (!!!)

Somehow, I never managed to find an answer until recently. I thought I might as well share what I learned, so here it is:

In Word 2000, go to tools -> track changes -> compare documents.

Here are a couple of refernces for your reading satisfaction :

http://my.brandeis.edu/bboard/q-and-a-fetc...g?msg_id=00000q
http://continuinged.uml.edu/online/tutorial/word_tracking/
 

https://forums.techguy.org/threads/solved-fyi-comparing-documents-in-ms-word.421483/
Relevancy 50.31%

hi all,
im wondering if there are any major differences
between the epson artisan 810, 800, 710 and 700 (beside price)
thanks!
 

Relevancy 50.31%

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

Is there any significant difference between Star Office and Open Office? Both are by Sun Microsystems, but "Star" is paid, and "Open" is free. They look the same from the screen shots...
 

A:Solved: comparing two office suits

Hi,
I think Star has a few more functions? But you can get it free from Google Packs. Download & installation no problem from this link. Just pick the progs you want:
http://pack.google.com/intl/en-gb/pack_installer_new.html?hl=en-gb&gl=uk&ciNum=11

Richard.
 

https://forums.techguy.org/threads/solved-comparing-two-office-suits.753683/
Relevancy 50.31%

Hey,

Any one know of a web site that you can compare graphic cards side by side? That way I can see which one is faster spec wise.

Thank you for your time,

Bigk
 

Relevancy 49.88%

Just want some opinions on which is the better brand, Western Digital or Maxtor.

I am looking at a 160 gig WD as opposed to a 200 gig Maxtor. WD is at Office Depot for $29.99 after rebate, the Maxtor is $49.99 after rebate, so the price diff is not that much.

I have already been told that Seagate is the best as well.

Thanks for your input!

ThaBrudda
 

Relevancy 49.88%

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

I have just retired my 17" Mitsubishi Diamond Plus CRT monitor with a thin, flat, wide 19" monitor HP HSTND-2351-L (L1908W) which I am very pleased with.

But what I really want to know is how to compare the running costs of the two monitors as neither quote the watts used.

Can anyone help with this or provide a link to a site, please?

johnni
 

Relevancy 49.88%

Hello I m writing some C code for an embedded application and I ve run into a problem wherein a compare Not Solved: Enumerated Type Value Correctly Comparing against an enumerated value is not being executed correctly Take the following code snippet for example Code Solved: Enumerated Type Value Not Comparing Correctly typedef unsigned int UINT typedef enum enum items tag ITEM ITEM ITEM ITEM MAX ENUM ITEMS enum items t UINT n for n n lt MAX ENUM ITEMS n Do something The code executes as expected until n is incremented to equal MAX ENUM ITEMS at which time the compare fails and execution continues within the loop when it should have exited I ve done things like this in the past without any problems I ve tried re-typing n as enum items t i e declaring n as quot enum items t n quot as well as type casting MAX ENUM Solved: Enumerated Type Value Not Comparing Correctly ITEMS as UINT The only other thing I can think of at this point is that maybe there is an issue with the number of items there are in my enumerated type Does anyone know if there are such constraints on enumerated types I m using a GCC based compiler Or if you have any other ideas it would be much appreciated Thanks nbsp

A:Solved: Enumerated Type Value Not Comparing Correctly

I found the problem. As usual, it turned out to be really simple. My INVALID_ITEM item was positioned at the beginning of the enumeration. When I moved it to the end, after MAX_ENUM_ITEMS, things lined up and started working.
 

https://forums.techguy.org/threads/solved-enumerated-type-value-not-comparing-correctly.864997/
Relevancy 49.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 49.45%

YSB I really tried to figure this one out on my own I have looked through the indexes of two books searched through my Access links even did a search on a Access UBB and still come up with nothing It seems like it would be a common enough control I am really surprised that the solution is eluding me Ok with that out of the way How do I compare two Access and two greater the selecting (Solved) 97 Comparing fields in fields and pick the greater of the two values Form rate rate and unboundfield The unboundfield s control source should select whichever value is greater The IIF function is not covered very well (Solved) Comparing two fields and selecting the greater in Access 97 in my (Solved) Comparing two fields and selecting the greater in Access 97 Mastering Access book so I am not sure if that is what I need or not It seems similar to the conditional control iif total gt total EXTRate that I have tried to convert that one to work ------------------ Building the Ultimate site list for PC support This message has been edited by Talismanic edited - - nbsp

A:(Solved) Comparing two fields and selecting the greater in Access 97

DOH!!!

This seems to work =IIf([rate1]>[rate2],[rate1],[Rate2])

Thanks anyways!

------------------
Building the Ultimate site list for PC support.
 

https://forums.techguy.org/threads/solved-comparing-two-fields-and-selecting-the-greater-in-access-97.36819/
Relevancy 49.45%

Hi Guys I am attempting to read in a CSV file and compare the results against another piped outcome Where the results appear in the imported file then I don t want to progress any further else I want to copy the file from the present location to somewhere else I came up with the following code which gets a rather nasty error Could someone please offer me some assistance Code DateToCompare Get-date AddDays - tostring quot ddMMyy quot Use when comparing todays file CONDITIONDIR GET-CHILDITEM -PATH URL quot file DEPARTMENTS quot DEPARTMENTS URL WHERE-OBJECT -NOT PSISCONTAINER -AND lastwritetime tostring quot ddMMyy quot -eq DateToCompare IMPORTCSV IMPORT-CSV quot URL quot file vempsas RAP DEV DEPARTMENTS DAILY CSV quot DEPARTMENTS DAILY CSV URL quot SELECT-Object name lastwritetime length CONDITIONDIR EXPORT-CSV -PATH URL quot file DEPARTMENTS DAILY CSV quot DEPARTMENTS DAILY CSV URL CONDITIONDIR FOREACH-OBJECT IF FullName -EQ IMPORTCSV FOREACH-OBJECT FullName -AND LastWriteTime -EQ IMPORTCSV result Powershell to Solved: Comparing - a CSV Piped Input FOREACH-OBJECT LastWriteTime stuff quot DONT COPY quot Thank you for your help Regards Scott nbsp

A:Solved: Powershell - Comparing CSV Input to a Piped result

I can tell you right now that I can't really name another user on this forum that uses PowerShell. TheOutCaste and I started learning it a few years ago but so little people really asked for help on it that we really didn't pursue it much.

I would attempt it using BATCH if I understood what you were doing but I am confused on what you are trying to accomplish.

If you could give me an example of what your input looks like and what the script is suppose to do and what you want your output to look like I may be able to code something in batch.
 

https://forums.techguy.org/threads/solved-powershell-comparing-csv-input-to-a-piped-result.1051774/
Relevancy 49.02%

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

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

Hello everyone,

I need a help regarding the contacts being synchronized with Outlook. All my contacts have their first names under 'First Name', but their last names under 'Middle Name'. I want to copy the middle names of everyone to the 'Last Name' box. Can anyone please help me on this. There are more than 700 contacts and I can't be doing this individually for each contact.

Any sort of help will be appreciated.

Thanks.

Regards,
Abhishek Sharma

A:Microsoft Office Outlook 2007 - Change middle names to last names

A quick fly by...
Links that might provide info below.

Customizing the Filing Format for Outlook 2007 Contacts

Display the Contacts list in last name, first name format - Outlook - Office.com

http://www.sevenforums.com/microsoft-office/189839-microsoft-office-outlook-2007-change-middle-names-last-names.html
Relevancy 46.87%

Probably it doesn't and my question is a long shot - but I recently toasted a drive, and it had many folders and files which I have little memory of. I also never used one of those nice apps that makes a list. Any help appreciated. Much obliged.


Tt

A:Does Windows save logs somewhere that shows folder names / file names?

Windows does not maintain such a log.

http://www.sevenforums.com/general-discussion/354125-does-windows-save-logs-somewhere-shows-folder-names-file-names.html
Relevancy 46.44%

Hello If this post is in the wrong area please let problem...convert text a string of to Novel columns... me know and I will move it Also if anyone can help and needs a sample of the Novel problem...convert a string of text to columns... spreadsheet let me know and I will post it I have a large database that is coded in MS Access One of the fields that we need to do an analysis on Novel problem...convert a string of text to columns... is selected in the database as a lookup list It is stored as text in the dbase When an excel spreadsheet is exported with this data one of the fields called ShortHandNotes contains all of the text items from the original database in alphabetical order For example ShortHandNotes Column Name in Excel Ant Capsular fibriosis see notes Chop Dense Maloney RB in OR see notes Vannas see notes VB Now the delimiter between the text items is a semicolon I know how to use the neat function in excel quot Text-to-columns quot to separate these items into columns Here is where the problem lies I need to get each of the text items in the above list for example Chop into a column named quot Chop quot The issue is that every record of them could have a variable amount of shorthand notes For example another record could be like this Dense FIS Maloney Small Pupil VB Viscodilate The only commonality between these lists is that there is finite amount of notes I think there are only possible shorthand text items and that they are alphabetical So right now I would have to extract the text to each column and then create new columns for each of the text items FIS Dense Chop etc and then sort each of the newly made columns alphabetically and then manually move over a chunk of data that matches Question is there a better way to do this It could actually take weeks or so to move each of these items over in blocks and there is a high possibility that a mistake could be made modifying each record The data to be analyzed is ultimately going to be binarized for medical research so the fidelity of the data is of paramount importance For example Dense FIS Maloney Small Pupil VB Viscodilate Would be extracted to columns named quot Dense quot quot FIS quot quot Maloney quot quot Small Pupil quot quot VB quot quot Viscodilate quot I would then globally search and replace each of the text fields in that column and flag them with a if blank it would be In this way I can then do a logistic regression to test for these indicators Any help anyone can provide would be appreciated Thanks in advance Jaysen nbsp

https://forums.techguy.org/threads/novel-problem-convert-a-string-of-text-to-columns.1009665/
Relevancy 46.44%

I don't really know what I did to cause the problem, but whatever it was I didn't intend to do it. I no longer have letters up for the column headers, this makes it a real pain to type in forumlas.

Anyway, attached is a screenie of what I'm talking about, anyone know how to make it normal again?

 

A:Excel Columns Problem - No letters, numbers instead

In Excel, click Tools/Options
Select the "General" tab and UNtick the "R1C1 Reference Style" checkbox.
 

http://www.techspot.com/community/topics/excel-columns-problem-no-letters-numbers-instead.25743/
Relevancy 46.44%

I don’t save that many songs on my Laptop but occasionally I save 1 or 2 from some Internet Radio and later I transfer to my USB for my car. I have Vista Home

However when I save songs on my Laptop, it changes the columns on my Internet Explorer to include “Artist, #, Album, etc” which I don’t need and removes the columns I like. The only columns I have for all my directories are “Size, Type and Date Created”

I know I can go and remove the unwanted columns and bring back the ones I want but is there a setting somewhere to prevent songs making their own columns?
 

Relevancy 46.44%

Hello,

I hope someone here can help for I don't want to have to type 300+ rows...

Column A has a user's full name.
Column D has a number.

So, say column A says; John Smith
Column D has a number 4

I'm looking to have Column B combine name and digit so result in column B would be;
4th line presence on John Smith's line

Is this possible?

Thanks
 

A:Solved: Combining columns?

You can us the & functio to combine (Concatenate) data.
So column B, (assuming row 2) could have
= d2 & " Line presence on " & a2
 

https://forums.techguy.org/threads/solved-combining-columns.712147/
Relevancy 46.44%

I want to have columns that have text of unequal length All columns will have bullet format - it s a quot things to do quot document I want to be able to jump from column columns formating Solved: to column to column to add a bullet to the particular column as needed I can t seem to get the cursor to be in the nd or rd column without filling the first column with text How do I do that I will later add a single quot column quot section of quot normal quot text to follow the -column section I believe I do this with a continuous page break Right Do I have to add the page break after the end of the rd column or can I establish the page break before I type anything in the rd column let s say I m typing in the nd column and decide to put some text below the -column section in the quot normal quot formatted section - how do I establish the page break and then go back and say type in the rd column etc nbsp

Relevancy 46.44%

Novice to Excel... I know basics, but this is over my head... and it looks like this is the place! (now that I've buttered you up, on to my problem! )

Basically I have a sheet with all data in Column A
Bob Smith
ABC Company
123 Main St
Anywhere, USA
Phone 555.1234
Fax 555.4321
Jane Doe
XYZ Company
321 Main St
Somewhere, USA
Phone 555.0000
Fax 555.0001
Etc…

I was hoping to get:
A | B | C | D | E | F
Name | Co Name | Street | Town | Phone | Fax
Name2 | Co Name2| Street2| Town2| Phone | Fax

The Copy Special – Transpose won’t do multiple rows it ends up with everything in one row as opposed to everything in one column
(Name Co Name Street Town Phone Fax Name2 CoName2 Street2…etc)

Any help would be appreciated!

PS - WinXP and Excel 2003
 

Relevancy 46.44%

I want to hide a few columns on a spreadsheet after I run a macro. I'm familiar with making sheets visible and hiding them with a macro, but not sure I know how with columns. Any help.
 

A:Solved: How to hide columns

Set the width to 0? That will effectivly hide them.
 

https://forums.techguy.org/threads/solved-how-to-hide-columns.423412/
Relevancy 46.44%

I have two Workbooks
One with part number and sales rank, the second I have part number and description information.
WB1:
PN Rank
10001 1
10005 2
10010 3
etc
WB2
PN Description
10001 Black Floormat 48x60
10002 Black Floormat 48x72
10003 Grey Floormat 48x60
10004 Grey Floormat 48x72
etc

How can I make a WB with PN, Rank and Description together? The problem is WB2 has a lot of part numbers that is not in WB1 and I do have the time to delete by hand...
 

A:Solved: Compare Columns

I'm sure someone will be able to help, but just a comment - this would be soooooooo easy in Access.
 

https://forums.techguy.org/threads/solved-compare-columns.559821/
Relevancy 46.44%

I have a GB HD NTFS DOS accepted Long names Short ok not file names file system with GB free space My Documents and setting folder has GB with Files and folders that are many layers deep The problem Every so often my XP professional OS will not accept a new long file name less than characters and spaces but will accept an character DOS name What is wrong Have I reached a Long file names not accepted Short DOS names ok limit because of the long file names Or too many files in a single folder Or I Long file names not accepted Short DOS names ok run into the same problem with by back-up Hard Drive which has a FAT file system The problem seems to go away at least for a while if I restart my Dell Dimension PC Thank you Supportbob I have replicated my problem both for my NTFS drive and the FAT drive I also finally got an error message which tells me the problem The maximum character and space limit of includes file name plus the names of all the stacked folders after My Dicuments The whole file path It can be very confusing because I was able to make it more than characters and spaces but all of sudden it reached a threshold where it will no longer work until I shortened the file name back to Going between hard drives seemed to make it recover sometimes when I had a longer than path but then all of a sudden it stopped working I need to keep my folder names shorter and be cautious on length of file names too when I have many stacked folders nbsp

A:Long file names not accepted Short DOS names ok

From what I recall the WinXP limits it to 255 characters, filenames written command prompt are 253 characters, and those include the filename and extension.
 

https://forums.techguy.org/threads/long-file-names-not-accepted-short-dos-names-ok.397432/
Relevancy 46.01%

css pull down menu - does not clear columns (web page problem)
Using CSS menus

I used CSS menus as PULL DOWN web pages menus

so when you click on the YELLOW (black lettering), the BLACK (with yellow lettering) pulls down

ie: Home Page
Map Espana

Each COLUMN disappears when you go to the next column.

Here is the problem:
but when you click "stop the music"

the columns of menus STAY - they do not "refresh" and disappear to show the NEXT menu column

web pages with music:

http://www.3973cds.com/3973cdssidislimane.htm
http://www.3973cds.com/3973cdspartytime.htm
http://www.3973cds.com/3973cdspartytime2.htm
http://www.3973cds.com/3973cdshome.htm

me:

www.schiffkey.com

[email protected]
 

A:css pull down menu - does not clear columns (web page problem)

Try adding a mouse event for when you remove the mouse pointer from the menu or change the event so it is only active when the mouse pointer is on the menu.
 

https://forums.techguy.org/threads/css-pull-down-menu-does-not-clear-columns-web-page-problem.749999/
Relevancy 46.01%

How do I move between columns in word? I know how to create columns. I know if I go to the bottom of one column it continues on the other. But I'm interested in writing an address on the left and jumping to the right and writing another address. I'd like to move back and forth between the columns w/o going to the bottom of the page. Is there a way. Thanks, Jex
 

A:Solved: Move Between Columns In Word

If you mean within a table - TAB
 

https://forums.techguy.org/threads/solved-move-between-columns-in-word.275535/
Relevancy 46.01%

Hi Guys,

I am trying to build a spreadsheet to analyse some data, I need to be able to sort totals into time columns,

If Column 'A' is the total, Column 'B' is the time and Columns 'C' onwards are the time slots from 07:00 to 17:00 in 30min increments, I need a formula so that if I have say 10 in 'A1' and 08.45 in 'B1', then 10 will be the result in 'F1' ie the column for 08:30 - 09:00.

Is this possible, would save me an awful lot of data inputting if it is, I am using Excel 2002 SP3 with XP

Phil.
 

Relevancy 46.01%

Hi everybody,

I can't get the following macro proper.

I need a macro which copies S1:V64 (In S7 starts the data, but I think it is more easy tot start at S1) to another column. Column W till Z. When the macro is pressed for a second time, cells S1:V64 (or Cells W1:Z64) needs to be copied till AA till AD et cetera. I have attached an example of my page. The thing is that the row with totals, should move to the right. So this should be always at the end of it.

So does someone know which macro I need?

Something like (it's not correct, I don't know how I have to write it correct.

Selection S1:V64
ActiveCel.Copy
But then I need the row to be inserted before the Total row. Is someone able to help me?
Hope it's clear what my purpose is?

Thanks in advance!
 

A:Solved: Insert columns macro

Not necessary anymore! Found another solution.
 

https://forums.techguy.org/threads/solved-insert-columns-macro.728416/
Relevancy 46.01%

Hi,
Is there anyone who could help me with one macro? This is the format of the data:

Picture1

And this is what I would like to have at the end:

Picture2

So basically I need a macro that would copy column D&E and put the data below B&C, also copying tasks respectively. and then the same for all other columns. The problem is that the number of columns varies... sometimes it's 30, sometimes it's much more.

Thanks in advnace
 

A:Solved: macro to move columns

Welcome to the forum fenrost.

Is there always going to be 7 tasks?
 

https://forums.techguy.org/threads/solved-macro-to-move-columns.934438/
Relevancy 46.01%

I remember seeing somewhere that you can convert rows to columns in Excel, where the numbers would be across the top and the letters down the side. How is that accomplished? Also, if there is data in the spreadsheet at the time, will it be converted too or will it just change the tabs?
 

Relevancy 46.01%

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

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

Hi all. First post so be kind! Bit of a novice at VBA, but i am sure this is possible..
basically, I have a contact list in Excel that I need to format 'correctly'. It is currently formatted with the address on multiple rows, with phone number and email address in another column ( i have attached a dummy file). I would like to 'move' data so it is in correct columns...
Name Address1 Address2 Address3 Address4 Address5 Phone Email

To make matters a bit trickier, the number of address rows varies, so it might be 5 rows or sometimes 3; and not all contacts have an email address (although they would always be in row "2" of a contact address.

Many thanks in advance for any advice

Finspa
 

Relevancy 46.01%

Hi All, fantastic site.

I need to run a macro in excel to sum the following.

check row 3 col 3 or row 3 col 4 for a value > 0 then subtract this value from row 3 col 5 return answer to Row 3 col 6 if col 5 cell is empty then go to previous cell that has a value >0 return this value to Col 6 on the same row as col 3 or 4 (the one with a value >0)
There should be an answer in every row col 6 this could run upto 100 rows+

Hopefully i've explained myself engough for you to understand. Ta
 

Relevancy 46.01%

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

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

Hello, I have data which contains vertical lines I'm trying to remove via "text to columns". The data varies in length so doing the "fixed width" option works by sections. I'm trying to use delimited, yet can't seem to insert the delimiter in the "other" box.

data looks like this: |10030|2009 | |

I'm separating the 10030 from 2009, and as I said the first # can be 5,6 or 4 digits. Is there a way to keyboard code the unicode vertical separator?

Thanks in advance!
 

Relevancy 46.01%

I had a similar post and thought it I understood the solution, but did not. Solution called for Pivot tables and it's not quite working for me. Just wondering whether a VBA file would better serve the purpose. Please look at the attached file. Many, many thanks for the kind help. (Running Excel 2003 on an XP- SP3 machine.)
 

Relevancy 46.01%

Hi All,

I need an help in finding out duplicates values in two different columns. Like for example i have Column A and COlumn B , suppose if any value in Column B if its available in Column A then i need to update as "1" in column C. How i can do that in access. Becuase i tried to give the criteria as "Column A = COlumn B" but this is not working effectively. Find some samples below;

Column AColumn BColumn C1111245658796565879657896524789652456977455697745564789656478965202786520278647008874700887419898841989883697090369709031951913195191168949526932931187597219139468569851689495123456511875977899555568569854557899

In this example the second row value in Col A is available as first row value in COl B , in this case i need to update as "1" in col C in second row.
 

Relevancy 46.01%

Hi,
I have a macro that performs a sorting function and the data in column "I" gets pasted into columns J,K,L once it is separated and sorted. The issue is that I have existing data in those columns.
I figured that If I add to the macro that already exists a command to add three columns to the right of "I" this would fix my issue...yes?no?maybe?
I have been googling to find insert macros, but they all seem to be weird ones (e.g. insert a column every 96 cells etc.)
SOLVED!!!
 

A:Solved: Macro to insert 3 columns to the right

There's a button 'Mark Solved"

The text SOLVED does not show up so people will uneedingly open this post.
 

https://forums.techguy.org/threads/solved-macro-to-insert-3-columns-to-the-right.1041202/
Relevancy 46.01%

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

I am really new to Excel (2003) and have read several similar posts to mine below; but cannot adapt the existing programming to accomplish the task. I wish to convert a data in “Book A” to appear like that of “Book B”
This will be an almost daily repetitive task. Please refer to the attachment. Thanks for looking. Any thoughts on the subject will be greatly appreciated.

System information:System Board: ECS K7S5A Chipset: SiS 735
CPU: AMD @ 1200 MHz
System Memory: 4x1024MB (DDR SDRAM)
Bios: AMI (11/21/01)
Video: onboard
Audio: Creative SB Live!
Op System: Win XP - Pro SP3 with all updates
 

Relevancy 46.01%

i tried looking around for a similar macro that would delete all columns except few based on the name in row but all i could find is deleting rows based on condition not deleting columns as i need and doing the additional things that i need i need this macro to do couple of things here is the breakdown remove all columns except few based on row name except columns some in Solved: particular headers 1 all with delete row remove entire Solved: delete all columns except some with particular headers in row 1 row based on a condition rename some titles in row reorder the entire sheet based on date in order from oldest to newest first i ll explain my excel sheet then below is the bits of code that i think is correct just need to put it together this is my excel sheet to make things easy i will only write out the names of the Solved: delete all columns except some with particular headers in row 1 columns i would like to keep Column A row Supplier Column B row Quantity Column C row UOM Column D row blank --- i also want this column removed Solved: delete all columns except some with particular headers in row 1 but has no name Column E row Destination Type Column F row Item Column H row Item Description Column I row Location Columns J - L -- remove Column M row Subinventory Columns N - W -- remove Column X row Order Columns Y - AP -- remove Column AQ row -- yes this is what its called when exported from the database Column AR -- remove i need to remove the columns from above I have a code that will delete the items that i dont need by writing out the column names but i want it the other way around so it will delete everything except what i need this macro below is only half of the actual length Code Sub ReceiveOnly lastCol Cells Columns Count End xlToLeft Column For delCol lastCol To Step - If Cells delCol quot Rev quot Then Cells delCol EntireColumn Delete Next lastCol Cells Columns Count End xlToLeft Column For delCol lastCol To Step - If Cells delCol quot Secondary Quantity quot Then Cells delCol EntireColumn Delete Next lastCol Cells Columns Count End xlToLeft Column For delCol lastCol To Step - If Cells delCol quot Secondary UOM quot Then Cells delCol EntireColumn Delete Next lastCol Cells Columns Count End xlToLeft Column For delCol lastCol To Step - If Cells delCol quot Person quot Then Cells delCol EntireColumn Delete Next lastCol Cells Columns Count End xlToLeft Column For delCol lastCol To Step - If Cells delCol quot Locator quot Then Cells delCol EntireColumn Delete Next End Sub i need to remove rows under Column E quot Destination Type quot that has the word quot Inventory quot so from a previous code i had Code Sub Delete Columns quot E E quot SpecialCells quot Inventory quot EntireRow Delete End Sub i need to rename some of the titles so after process above the excel sheet should be Column A row Supplier Column B row Quantity Column C row UOM Column D row Destination Type Column E row Item Column F row Item Description Column G row Location Column H row Subinventory Column I row Order Column J row so here is what i was thinking for this Code ActiveSheet Range quot B quot quot Qty quot Range quot H quot quot Sub Inv quot Range quot I quot quot PO quot Range quot J quot quot Dock Date quot nbsp

A:Solved: delete all columns except some with particular headers in row 1

any help with this would be great, thanks!
 

https://forums.techguy.org/threads/solved-delete-all-columns-except-some-with-particular-headers-in-row-1.841974/
Relevancy 46.01%

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

When I attempt to insert a column or a row, I'm getting a message from MS Excel:
"Cannot shift objects off sheet".
Can someone advise me as to what I must do to correct this?
Also, what have I done to cause this to happen?
Thank you for your help.
 

A:Solved: Inserting Columns or Rows

hi floydcojacket,

I think this is connected with your earlier issue with cell comments.

I'm now sure you must have your Advanced Options, Display Options for this Workbook- Display Objects set to Hide.

That option is in the next block below the Display options for Comments.

lol
Hew
 

https://forums.techguy.org/threads/solved-inserting-columns-or-rows.992496/
Relevancy 46.01%

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

In Sheet one I have some raw data which in sheet two I have picked out the useful pieces and Fill another across sheet in move rows to Excel I problem. need columns have then input into out work forms The problem is that I need to fill the form across column but in the sheet that it is referenced from I need it to take the data from the row EX sheet one a b c a b c a b c a b c I Excel problem. Fill columns I need to move across rows in another sheet need to find a way to automatically get it to do this referencing sheet in column A and then filling to the right but actually having it go down the rows in sheet sheet a b c a a a b b b c c c the idea is that when the software exports to sheet we will be able to print sheet two in the form we need it without having to make any changes I know my explanation is a little crude but if someone could help me I would appreciate it thanks nbsp

A:Excel problem. Fill columns I need to move across rows in another sheet

You could use:

=OFFSET(Sheet1!$A$1,COLUMN()-1,ROW()-1)

in Sheet2!A1, then replicate that down an across (pro forma style).

Would that help?
 

https://forums.techguy.org/threads/excel-problem-fill-columns-i-need-to-move-across-rows-in-another-sheet.1035094/
Relevancy 45.58%

I noticed recently that my system and other folder names have changed on their own! What the -h- happened? I have never seen anything like this before. These folders appear on all of my drives c:, d:, g: and they are random. It looks like they are of another language, maybe? Actually, the wording makes no sense at all...> It looks like most of these folders previously existed.

Things I have done: Ran Anti-V program + Ewido Suite = No viruses, trojans, malware, etc. Ran three adware programs (ad-aware, spywareblaster, spyware doctor) = Clear. Checked all running processes and startup tab in mscofig = no peculiar programs detected. Ran regseeker = Phenominal amount of invalid keys, etc. (3,000+) very unusual to the norm!!!

Any help would be greatly appreciated...

System Spec's: WinXP SP1-current updates, 384 RAM, AMD 1.15 GHz processor
 

Relevancy 45.58%

Can anyone point me in the right direction? Using office 2003
I have a list of about 200, 7 digit random site ID numbers and each one has a corresponding access code of 4 digits.
What I want is to put them all onto one page to print and have an easy reference. I can do it manually cutting and pasting into tables but every week, 2 or 3 new sites get added to the list so I have to manually edit each column and it in turn puts the format of the table off.
Is there a way to do a 'wrap' as in 'word wrap' on a text doc so the column would move down and the last entry would wrap up to the top of the next column?

thanks in advance
 

A:Solved: multiple columns on one page for printing

Hi arrrgh2003,

Isn't this simply using Columns in WORD (Format / Columns), then if you copy and paste the whole of your source into it, it will format into the no of columns you have created.

lol
Hew
 

https://forums.techguy.org/threads/solved-multiple-columns-on-one-page-for-printing.402169/
Relevancy 45.58%

My dad pitched me this question to pose to the board membership Start All Three - Solved: Menu All Seeing Programs Columns He s running Windows XP on the desktop computer and he s got quite an extensive collection of programs after a good number of years now The problem is that when he accesses the Solved: Seeing All Three Columns - Start Menu All Programs Start Menu and selects All Programs the column menus now extend to three columns The Solved: Seeing All Three Columns - Start Menu All Programs difficulty is that the far right most column is not completely visible on the screen now Given my dad s fairly advanced age I m afraid that modifying the screen resolution setting is really not an option Exclusive of some well-intentioned suggestion to pare down the number of programs on the All Programs menus that s not going to happen are there any other suggestions or fixes circulating that would somehow reorient the All Programs columns when they pulldown And selecting the option to only display recent programs on the All Programs menu is also probably not an option nbsp