Add Names Based On Number Of Question Correct

Oct 19, 2009

I need the names of students from Summative tab in the correct box based on how many question they got correct. (Q 27-32, (0-1, below, 2-3, Average, 4-5, Above Average, 6, Excellent Performance. )
I have attached a file.

View 8 Replies


Copy Correct Multiple Choice Answer Into Field Based On Number Identifier

Mar 23, 2014

I have a set of 4 multiple choice answers B,C,D,E column "F" lists a # 1-4 which lets you know which column letter (b,c,d,e) the correct answer is in. I want to set up a formula that will copy the contents of the correct answer (based on that # identifier) and copy it into column "A" which is currently blank.

View 7 Replies View Related

Index And Match Formula: Return The Correct Serial Number Based On Both The Matching

Jun 24, 2009

I'm trying to create a formula in cell f13 of my attached spreadsheet "Sample 1" that will search the 2nd attached spreadsheet "Sample 2" and return the correct serial number based on both the matching PO # (located in cell E10 on Sample Sheet 1 and in Column 5 on Sample Sheet 2) and Product # (cell A13 on my Sample Sheet 1). My current formula is not returning the correct result and I'm not sure why.

View 4 Replies View Related

Copy Correct Multiple Choice Answer Into Blank Field Based On Corresponding Number Identifier

Mar 23, 2014

Here's an example of what i want to do

A_________ B Frank Sinatra C Sammy Davis D Dean Martin E Joey Bishop F 3

I want to put "D"'s value 'Dean Martin' in column A - i know it belongs in A because the "3" in column F indicates its the 3rd answer listed i.e Dean Martin. This format would be the same where there are 4 possible answers on the column to the right dictates which answer is correct.

View 2 Replies View Related

Sum Values With Names Based On A Number Prefix

Feb 4, 2010

How can I sum values with names based on a number prefix? For example, in the attached sheet, how can i sum all values that have the prefix 4.10.02.xxxx?

View 2 Replies View Related

Save As Based On Other File Dates In Names. Increment Number In Name

Mar 4, 2008

How would I save a file with the lastest version number after searching for the lastest filename in a folder and adding 1 to the name

ActiveWorkbook.SaveAs FileName:= _
"C:BarkingEMCOUTNOM_DA_" & (Format( Date, ddmmyy)) & "_EDF_BPL_" & V, FileFormat:=xlCSV

where V will be the version number in the format of 001, 002, 003 and so on

View 7 Replies View Related

Basic Cell Referencing - Return Correct Names And Values On Another Sheet?

May 13, 2013

Here's the data table being referenced

Week Ending


[Code] ........

Now on another sheet, I want to return the top two 'Name's and their values like below:


There is a fluctuating amount of rows in the first table, too. So what formula can I use to return the correct names and values on another sheet?

I'm thinking it will use some form of concatenate for the first and use a sumifs function for the value column..

View 1 Replies View Related

DateTime Stamp With Correct Number Format?

Nov 25, 2013

I am trying to date and time stamp a certain cell. This cell is going to be compared to another cell in another sheet (also date and time) so that I can track deadlines being met.

I am using the following code to stamp the cell:

Range("F26").NumberFormat = "[$-409]m/d/yy h:mm AM/PM;@".Value = Now()

Even with the number format, the cell is not stamped as a number. As a result I get #value errors when I take the difference between the stamped cell and the cell with the preset deadlines.

View 2 Replies View Related

Move Row Data To Correct Tab If Serial Number Is Not In Tab?

Apr 23, 2014

I am trying to do with this spreadsheet project,

On the "Master" tab, I would paste in the newest information received from our system weeklywhich is around 2600 rows. I want to then compare the Master sheet to the other tabs and if there is a new Serial Number present in column I, then add that row of data to the next available row at the bottom to the correct tab.

The Orange tabs Fleet Volume PC, Fleet Volume BW, Fleet Volume Duplex will house all countries and all serial numbers but Fleet Volume Color tab will only have Color Serial Numbers for all countries, column J on the Master tab.

So, the same will goes for the USA Volume and CAN Volumes tab, only those serial numbers for that country will falls in these tabs and color only will go in the color tabs. There are 14 other tabs missing from this workbook with other countries, just removed to keep size of file within limits.

From my workbook, rows 29 to 33 on the Master tab are new serial numbers.

Also, I want to highlight the data on the Master, after comparing this Master tab to the other tabs and within the Master highlight in yellow the cells that have new updated information!

View 14 Replies View Related

Calculate Week Number And Call Correct Sub

Jul 19, 2014

I have two processes that has to run depending of the week number of the year. So even weeks has to run "sub 2" and odd weeks has to run "sub 1".

Weeks with number 1,3,5,7,9,11,13,15 etc has to call "sub 1" and weeks 2,4,6,8,10,12,14,16 etc has to call "sub 2".

The filenames consist of "name_name_YYYYMMDD.xls" (example: SteveSmith_Runningshoes_20140719.xls)

So vba needs to calculate the week number by reading the YYYYMMDD of the filename and then call the correct sub.

View 6 Replies View Related

QueryTable Not Returning Correct Number Format

Jul 28, 2006

I have a querytable running on my sql database. In the query I have a trimleft function because the numbers are stored with several proceeding blank spaces. When I execute the query through my macro, everything works fine, except I can't average or sum the results. They can be multiplied, divided, etc, but not averaged or summed (they just show as zero on summing, which makes the average DIV/0). The really strange part is that if I select a number and go to the formula bar and hit delete at the beginning of the number (which actually deletes nothing), the number is suddenly capable of actually performing as a number. I assume this has something to do with how the querytable is returning my results, but does anyone have an idea for a workaround for this issue?

View 3 Replies View Related

Excel 2003 :: Correct Approach For Number Format?

Feb 14, 2012

I have several sources of information for client files. the number format includes a reference number and a month, eg 123/11, 456/02. In some cases, the numbers may be presented including the company initials, eg ABC/00123/11. I want to make sure all numbers on all sources are the same as I am using Vlookup and this reference no to copy information from one source to another. Sometimes when I change the format Excel sees this as a date, eg 11/11 is 11-Nov, and in some cases Excel sees a fraction, eg 123/11 is 123 11ths or 123 divided by 11.

I can easily take out the reference no with a find and replace FIND ABC/ replace with . But this often results in a number with leading zeroes, eg ABC/0123/06 will leave 0123/06.

I am using Excel 2003.

View 1 Replies View Related

HLookup - Return Correct Number Of Rows Downwards In Table?

Feb 8, 2013

=HLOOKUP(G8,'Headline Assumptions'!$C$32:$F$37,E8,FALSE)

Above formula, in cell E8 is the number 3, however excel does not recognise this and returns 1. is there a way i can get E8 to see that it is a 3 in that cell and return the correct number of rows downwards in my table?

View 1 Replies View Related

Countif Formula: Added The Correct Amount In The Correct Cells

Feb 15, 2010

I'm trying to create a formula that will added the correct amount in the correct cells, I have create a dunny sheet in trying to achieve this. If Cell B8:B11 = ABS or Dum that any points won should be added to Cell L8:L11 right now its adding it into K8:K11. If Cell B8:B11 = is Blank any player points should be added to cells K8:K11. I'm using this formula throughout cells K8:K28 =IF(J8>J25,1,IF(AND(J8<>0,J8=J25),0.5,0)) Any thing in red is incorrect anything in blue is what I'm trying to achieve.

View 4 Replies View Related

Link Between Two Cells Is Broken So The Correct Number Is Not Showing Up In The Cell

Aug 6, 2007

I have a spreadsheet that has been sent to multiple clients. I have discovered an error in a few of the cells:

1. a link between two cells is broken so the correct number is not showing up in the cell. It is a simple formula ie: =A15, that I either forgot to put in or deleted in a fit of madness. It is in the same cell on the same worksheet in the workbook.

2. A hidden column on a worksheet has a formula that sums a range of cells. I have discovered that this range of cells is wrong. This error is duplicated on a number of worksheets in the workbook. The problem is that the error is in the same column in each worksheet but not in the same row.

Each worksheet is password protected. This is done through VBA code so the passwords won't be a problem.

The clients have already started working on the spreadsheet that I sent them and I want to send them a "fix" so that the correct formula will just update the spreadsheet they already have rather than me sending a completly new one and them having to start from scratch.

I had this wonderful spreadsheet set up with columns that appear and disappear and formulas galore so that the client didn't have to do to much work and then I find these errors after it has been sent. My testers let me down but that's life.

View 9 Replies View Related

Check Cells Are Correct Format And Contain Correct Data

Jan 26, 2014

We receive about 20 sales files of several hundred lines of data each day from various agencies. I want to create a macro / VBA code which checks that the data submitted is correct so that we can upload it into our database without import errors and / or having to manually check each line of data.

I envisage something like an output report:

149 entries
Column A - Date - OK
Column B - Customer_Phone - Errors (Should be 11 digits)
Row 21 - Customer_Phone - Error (Not 11 digits)
Row 108 - Customer_Phone - Error (Contains letters)
Column C - Outcome - OK
Please correct and re-check.

View 4 Replies View Related

Sumproduct- Counts The Correct Amount But Not With The Correct Dates

Jul 3, 2008

I have a table with 3 columns of dates and then a column with Set # that I
feel in the box #.

I need to see how many items processed for each set per day.


The problem is that it counts the correct amount but not with the correct
The formula that I use is:

View 14 Replies View Related

Find Correct Data Based On 2 Variables

Oct 19, 2006

I have a project that looks at a table of train schedules for a range of dates. The data is formated so that arrivals and departures are on the same row but differnent columns. The dates are to the right and the grid is completed with the number of arrivals for a paticular day. I have created a formula that looks at the data and returns the arrival time for that date. It worked fine until the schedule was altered so that the same train could arrive at 2 different times on 2 different dates. So train 976 arrives at 4a on some days and 5a on others. In the example Ihave posted train 976 has 2 passengers arriving at 5a but the formula shows 4a. Is there a way I can have the formula return the correct time based on the day of the month? I should point out that the same problem could exist for departures.

View 8 Replies View Related

Print Correct Chart Based On Last Month

Jun 14, 2007

to print last months results each month. I have a cell (range name = LastMonth) with formula =now()-15 to display last months full name since I will always do this in the first half of each current month.

I want it to look at that cell on the "FY" sheet, see what month is displayed
then go to the "Monthly Audit By Cell" sheet & print the correct chart.

Each chart is named "Jan Audit" and so forth

I have this - only first six months done so far. Problem is nothing happens-no printing!

Doing this today on June 14th should print out the May chart.

' Print the Audit for the current month

View 9 Replies View Related

Showing Correct Percentage Based On Monthly Figures

Mar 21, 2013

I have the following three columns of Data and I'm using this formula to calculate the %age difference cells:

=IF(ISERROR((F14-F13)/F13), " ", IF(ISBLANK(F14)," ",IF(F14=0,"-100%",(F14-F13)/F13)))

A - No. of Hits B - %age difference C - Weekly Average

50 100%
25 -50%
0 -100%
0 -100%

I have left blank the "cells" which are giving me trouble, and my troubles are as follow:

-Where the value of the previous month was 0 and the value of the current month is higher my output is Blank, ideally I would like this to show as 100%
-Where the value of two months in a row are 0 I would like the value to show as 0% for the second month

I did add extra into the formula so it would show the 100%, unfortunately it did this for any consecutive months at 0 also which was incorrect.

View 3 Replies View Related

Check If Abbreviation Used In Cell Is Correct Based On Given List?

Apr 24, 2013

I have a list of abbreviations in Sheet 2 and Names of Companies (Full name of Company and short name) in Sheet 1.

What I need to do is check if the abbreviation used in the Short Name Field in Sheet 1 is correct based on the given abbreviation list in Sheet 2.

here is the example:

Sheet 1:
Fulll Name of Company
Short name
Ameriprise Fin
Sheet 2: Abbreviation List
Full Version

in the abbreviation list the correct abbreviation for financial is Finl so the short name should have been "Ameriprise Finl" and NOT "Ameriprise Fin". I'd like the rows highlighted in yellow if it is incorrect.

View 9 Replies View Related

Disable TextBoxes And Input Correct Data Based On ComboBox Choice

Mar 24, 2014

when i choose material from my combobox Options (cboTM), i wanted, only the textboxes regarding to the sheet material unlocked, and the others locked with the color of the form, and the same for the other options like worklabor and equipments. i could blocked for material with this code :

[Code] .....

The prob is, worklabor and equipments will be blocked too, and i dont know how to put correct info on the textboxes.

Attached File :

View 5 Replies View Related

Correct Syntax For Function To Find Average Based On Background Color Of Cells In Range

May 20, 2014

I'm working on a workbook that will track staffing patterns.

The workbook has three worksheets: Sheet1 "RCS", Sheet2 "HCT' and Sheet3 "Hidden". I've attached the workbook to this thread. The password for the form is "j".

On Sheet3 "Hidden" I have two tables that are set up to collect the SUM of columns on Sheets1 "RCS" and Sheet2 "HCT". I'm finding the SUM of each range by way of the background color. I've set up the following formulas and when the "data collection tables" are in the same worksheets as the original information, the formula's work perfectly:

The following functions are pulling data from Sheet1 "RCS" and placing them into a table in Sheet2 "Hidden"

[Code] ........

The following functions are pulling data from Sheet1 "RCS" and placing them into a table in Sheet2 "Hidden"

[Code] .......

I have two more functions that aren't working due to the fact that the source values are percentages and NOT plain numbers. The above functions work great for SUM but not for percentages. EXAMPLE--Let's say, 3 sub percentages it gives me the SUM of the 3 percentages (i.e. 85% + 100% + 100% = 285% instead of giving me 95%.

[Code] ........

How might I use the following functions to find the average of the source fields instead of the SUM?

View 7 Replies View Related

Count Number Of Times Names Appear In Column?

Jan 6, 2014

I have a list of names all in one column, separated by row...


John Doe
John Doe
Jane Doe
Jane Doe
Jane Doe
James Jones
James Jones

I want to count how many times each name appears. Like this:

John Doe | 2
Jane Doe | 3
James Jones | 2

This is a very large list of names and I prefer not to have to type each single name into a formula because there are hundreds of separate names.

View 4 Replies View Related

Repeat List Of Names X Number Of Times?

Jan 10, 2014

I'd like to be able to repeat a list of names X number of times.

Example: Repeat count = 3




View 4 Replies View Related

Find Duplicate Number And Extract Names?

Nov 23, 2012

I have this data set,





View 4 Replies View Related

Returning A List Of Names Without The Prefixed Number

Jul 8, 2009

I have a list of names in say column A, but the names are prefixed with numbers. So, for example you have 2 Peter Jones, 5 Johnny Piper, 10 Andrea, 3 St. Mary's, 13 White etc.

I want to return these list of names in another column say B, but without the prefixed numbers. So, column B will have Peter Jones, Johnny Piper, Andrea, St. Mary's, White etc.

View 9 Replies View Related

Highest Number From File Names In Folder

Dec 22, 2009

I need a macro which checks for next available number from list of filenames in a folder. Then it returns that value to one predefined cell in a new document (here Untitled.xls). For example:

c: est

has the following files:
Untitled.xls - read only

Next available filename should be "abc-09-005" and macro returns that value to predefined cell in a new document (Untitled.xls). There should be NO saving at this point whatsoever. Macro simply picks the next value from a filelist. As you've noticed the value has some constants too. New document doesn't know the last picked value before macro is active (predefined cell should be empty at startup).

View 6 Replies View Related

Formula To Extract Undefined Number Of Names Following Specified Character

Apr 8, 2014

I need a formula which can pick out the names from string of text, each name follows "-->", the number of names in each cell differs and is undefined. The result needs to be posted into each column following these cells.

An example of a cell is below:


Loss -->--> Tom Aaron -- -- -- -- Strikeforce - Hen... U. DEC 3 5:00

-->--> Matt Ricehouse -- -- -- -- Dec. 4, 2010

Win -->--> Tom Aaron -- -- -- -- Strikeforce - Hea... SUB 1 0:56

-->--> Eric Steenberg -- -- -- -- May. 15, 2010 Guillotine Choke"

I have tried using text to columns but everything after the first line is not recognised (when I click finish anything after "TIME" is simply not there).

Example attached : UFCv1.xlsx

View 7 Replies View Related

Count Unique Names Only Not The Number Of Times It Appears?

Apr 4, 2013

I've got a set of data that I update once a month and the number of team members per team changes all the time. I'm trying to write a formula that basically says, if the date matches AND the manager name matches, count the number of team members.

In the attached sample if A2 and B4 are found in the data set, count the number of SalesReps they have. So I'm looking at Sarah for February 2013, she has two sales reps that sold something, but Katherine appears twice, so I'm not looking for a result of 3, the correct answer is 2. How do I write the formula?

A2 will look to the data range of A14:A23 and SarahK will look to I14:I23, but I want to count H14:23.

View 9 Replies View Related

Copyrights 2005-15, All rights reserved