Excel Sheet1 Comparing Data - Get Stuck After Second IF Statement

Aug 1, 2013

=IF(M7="","",IF(K8=J8,K8&$J$3&I8,IF(K8=I8,K8&$J$3&H8,IF(K8=H8,K8&$J$3&G8,IF(K8=G8,K8&$J$3&F8,K8&$J$3&J8)))))

I have tried several options, ISERROR(FIND(.................also EXACT(........ and they all seem to get stuck, after the second expression.

Basically, I have a ROW of Cells, with numbers inside them, like so:-

F8.....G8....H8....I8...J8....K8
27.....33....10.....4....4.....4

And looking from right to left, I am asking this question:-

If K8=J8, then I will have K8 & I8 as my result.
If K8=I8, then I will have K8 & H8 as my result.
If K8=H8, then I will have K8 & G8 as my result.
If K8=G8, then I will have K8 & F8 as my final result, Else its K8&J8 as my FALSE.
(the $J$3 = a comma, for number separation, and further LEN string capture.)

Every time I have made this formula, with other types of Logic, it only ever finds the second tier depth as the result,
and I wonder why, since they are several nested IF statements in line!!

The incomplete Excel sheet is attached : S 1_2 tracker Forum.xlsx

The result of the above formula should be 4,10
But instead I get 4,4

View 2 Replies


ADVERTISEMENT

Excel Gets Stuck On A Cell?

Aug 26, 2013

I have a client that enters a lot of data into various spreadsheets, we recently upgraded her computer and along with it upgraded Office to 2013. Since that has happened she has experienced some issues with navigating cells in Excel. What will happen is she will be typing than tabbing or using the arrow keys and all of a sudden the active cell will get stuck on one of them. Arrow keys do not move the cursor to the next cell and the only way for her to fix it is to alt tab to another spreadsheet and then back to the one she was working on. Once that is done it is working fine.

There seems to be no rhyme or reason to when this happens to her. I have re-installed (used the big one that re-downloads from the web), it has no add-ins on either that are conflicting and I know it is not the keyboard since when I log in through TeamViewer while it is happening I am also unable to move with the arrow keys.

View 10 Replies View Related

Excel 2010 :: How To Populate Sheet2 From Sheet1 After Finding Matching Word On Sheet2 From List In Sheet1

Oct 4, 2013

I have 2 Worksheets in an Excel 2010 Workbook -

Sheet1
Column1: contains the word "dog"
Column2: contains the word "bark"

Sheet2
Column1: contains the sentence "I like dogs a lot."
Column2: is blank

What I need to do is search Sheet2/Column1 for the presence of "dog" and if it's present, populate the word "bark" in Sheet2/Column2 from Sheet1/Column2.

How can I do this?

View 4 Replies View Related

Excel 2010 :: Y Axis Stuck In Middle Of Chart?

Feb 10, 2014

I have a bar graph in excel 2010 and the vertical access is stuck in the middle of the graph. When I right click on the axis and select "format axis" I have an option to set where the horizontal axis crosses but never the vertical.

View 1 Replies View Related

Export 2 Columns Data From 1 To 30 Sheet To One New Excel Or In Different New Sheet1

Aug 29, 2013

How to export data like name and percentage from all the sheet (30 sheets) to a new file or in a different sheet.

E.g

Name project target ,weekly %, and monthly percent% ,present, absent are there in all sheet but i want to export only Name and monthly percentage to different excel or different sheet in same excel.

View 2 Replies View Related

Excel 2010 :: Copying Data From Sheet1 To Sheet2

Dec 26, 2011

I have extracted a lot of data (from a webpage), onto Sheet 1 of my Excel 2010. The results I have obtained of this data I have extracted might occupy cells A1 to F1.

I want to keep doing this over and over, copying and pasting data from a webpage onto Sheet 1, then obtaining various results and adding those results under cells A1 to F1, which would of course be A2 to F2.

Is there any way these results can be transferred to say Sheet2, but of course occupying a new line each time so that at the end of the day, I have a list of results.

Of course I could just copy and paste them to say Sheet2, under each other, just wondering if there was some tricky way.

View 3 Replies View Related

Stuck With Dropdown List Data?

Mar 23, 2014

I am currently stuck with a drop down list problem. I am trying to make a benchmarking solution for a group of 20 stores. All stores sell products uniformly and their sales are displayed in percentages of the cumulative total. Currently there is a benchmarking page where all stores sales per product is displayed, however I would like the ability to select specific stores data from a drop down list. I have pictures displaying the basic concept of what I want to achieve.
stores.PNG

On the left a list of products and the quantities sold in percentages per store for benchmarking purposes.

What I would like to achieve relates to the drop down list on sheet 2.

store 1.PNG

Here store 1 can see its sales in percentages, and has a drop down list to compare to different stores. If store 3 is selected I would like the data to be pulled into that column from the benchmarking sheet and the same goes for the other stores of course.

View 7 Replies View Related

Open Another Excel File And Copy Data To Sheet2 While Button Upload Is In Sheet1?

Mar 27, 2014

how to copy data from one workbook to another workbook.

here's the process

1. Button upload is in book1 sheet 1
2. Copy data from book to book 1 sheet 2

Here's my code for starters.

[Code] ....

View 3 Replies View Related

Excel 2010 :: Comparing / Merging Child Spreadsheet (purified Data) Into A Parent One Raw Data)

May 17, 2014

I have a parent spreadsheet with raw data(with errors) and a child spreadsheet without errors. I want to merge the child into parent. (:{). I am thinking of comparing multiple columns from each sheet to ensure maximum accuracy. And when those columns match up we paste the corrected column data from child sheet to parent one. I am using windows 7 and Excel 2010.

View 1 Replies View Related

Comparing Data In Excel - Two Databases

Jul 18, 2014

I have two huge database and need to test if Employee name and ID in database A matches to name and IDin databse B. What formula could I use here?

Employee ID Database A
Employee Name Database A
Employee ID Database B
Employee Name Database B

1
JONES JR,STEPHEN W
1
NULL

[Code] ...........

View 2 Replies View Related

If Statement For Comparing 3 Values

Jun 25, 2014

How would I write a IF statement comparing 3 values. For example the field that it would be referencing would have values cell E51(1,2,3,4,5,6,7,...99). The pull back would be:

1-10 = $250,000
11-15 = $550,000
16+ = $750,000

View 2 Replies View Related

Comparing Dates In Two Columns Using IF AND OR Statement

Apr 14, 2014

I'm trying to determine if one date meets the criteria to be considered 'on time'. I have two columns: estimated completion date and completion date. I want to compare the completion date to the estimated completion date and if completion date is <= completion date but is NOT = 1/1/2099 then I met my date. I've tried this several different ways and problem is I cannot make it work.

When estimated completion date is 1/1/2099 'on time' should be 'no'
When estimated completion date is not 1/1/2099 but is greater than completion date 'on time' should be 'no'
When completion date is <= estimated completion date and estimated completion date is not equal to 1/1/2099 'on time' should be 'yes'

And I have a null date to deal with also but if I can satisfy the first 3 criteria I can manipulate the null values manually.

View 9 Replies View Related

Excel 2010 :: Comparing Multiple Columns Of Data (Last Name / First Name)

Aug 8, 2012

I'm using Excel 2010 on Windows 7.

I have 2 worksheets. One has Employees and the devices they have. Last name, First Name, Device each in their own colulmn. Many have more than 1 device so they have multiple entries on seperate rows.

Another worksheet has Employees and thier location. Last name, First Name, Location. Again, all on seperate columns.

It would look something like this

Sheet1
Lastname
Firstname
Device
Johnson

[Code]...

So I'm tasked with combining them into 1 sheet with last name, first name, device and location. The issues I'm having are:

1) A team member could have multiple devices
2) A last and/or first name can appear many times, so a simple Vlookup against lastname won't work - it has to somehow also compare against both.

View 6 Replies View Related

Excel 2007 :: Comparing Data In Table To Produce Value

Apr 8, 2014

I have two tables each containing a column with Account ID. I want to in table A put a column that will return a yes or value of 1 if the ID in that row shows up in the ID column in table B. I have windows 7 with excel 2007

View 1 Replies View Related

Excel 2003 :: Comparing Data To Locate Missing Fields?

Feb 8, 2012

I am in the process of comparing the data between 2 different sheets and the data on each sheet contains 2 columns of information. I am trying to find a way to compare one sheet to that same item on the second sheet and see if anything is missing, however the second sheet contains more information between the two columns and the rows are never the same during my comparison. I've tried Match, Lookup, Indirect, and if/then with an And functions and because the rows do not stay the same the data is not accurate. Here is a brief example of what I am working on:

SHEET 1
A B
1 Red Delicious Apple 125 Count Apple
2 Red Delicious Apple 125 Count Fresh Fruit

[Code]....

So in these comparisons, the names in Column A match identically, so if I try to say take the name from sheet 1 and match to that in sheet 2 and if the wording in Column B matches then put a "Yes" value. But you can see on Sheet 2 by the time it gets to rows 14, 15, 16, the Baby Food Chicken has a 3rd item in Column B in comaprison to Sheet 1, so any type of match doesn't work.

I am using Excel 2003.

View 9 Replies View Related

If Statement Failing When Comparing Text Box Values On Userform

Jun 12, 2014

I am trying to compare to values that a user inputs in a user form. It's ok if they are not the same I just want the user to know it. I am only including the part where the if statement is failing:

VB:
If Me.VSLongQuant.Value <> Me.VSShortQuant.Value Then
MsgBox VerUnBal
If VerUnBal = vbNo Then
Exit Sub
End If
End If

I have VerUnBal as Long and defined as:

VB:
VerUnBal = MsgBox("The Long and Short option Qunatities are not equal." & Chr(13) & _
"Is this intended to be an unbalanced vertical spread?", vbYesNo, _
"Unbalanced Spread Alert")

I can provide more info as necessary. There are two problems 1) the message box is appearing whether the numbers are equal or not, and 2) clicking No in the message box does not cause the Sub to exit.

View 6 Replies View Related

Excel 2003 :: Stuck On User-defined Type Not Defined Error?

Oct 9, 2012

Trying to convert an Excel 2003 macro to work in Excel 2007.

The problem line is

Dim MyDataObject As DataObject

I suspect the problem is a Missing Reference, but I cannot figure out which one. I have the same ones (in 2007) as 2003 except for one which is not showing

Microsoft Forms 2.0 Object Library

Is this the one it needs? It is called something else in 2007?

The ones I do have ticked are

Visual Basic For Applications
Microsoft Excel 12.0 Object Library
OLE Automation
Microsoft Office 12.0 Object Library
Microsoft ADO Ext. 2.8 for DDL and Security
Microsoft DAO 3.6 Object Library
Microsoft ActiveX Data Objects 2.8 Library
Microsoft Scripting Runtime
Microsoft XML v2.6

View 8 Replies View Related

Compare Sheet1 With Sheet2 And Copy Unique Values In Sheet1

Aug 13, 2014

I am using the below code and it is not performing the operations of comparing and deleting the duplicate values from sheet1 and pasting unique values in sheet 1, p.s. Do not need values from sheet 2, just want to compare the sheet 1 with 2 and delete dups in sheet1.

[Code] .....

View 2 Replies View Related

Excel Macros To Transfer From Sheet2 To Sheet1

Feb 5, 2014

i have created a catalog with an invoice, sheet 1 is my invoice and sheet 2-36 are the different categories. I need to transfer data from sheet 2 to sheet 1 Containing QTY, Item, Item ID and Price. from my understanding here is what is needed to start the transfer from sheet 2 to sheet 1....

sheet 2 (catalog)

A -- B -- J -- M
QtY -- Title -- Item ID -- Price

sheet 1 (invoice)

A -- B -- E -- F
QTY -- Title -- Item ID -- Price

View 14 Replies View Related

Excel 2007 :: Open Sheet Always On Sheet1 A3

Feb 2, 2014

Am using a VB for auto transpose values to sheet 2 from sheet 1 in MS EXCEL 2007.

What code to add to the already existing VB so that if someone is using the sheet and leaving the cell in E12, for example, and saving it, then the next user should find it again on A3 but not on E12.

The sheet should always open on A3..

View 4 Replies View Related

Formula To Separate Specific Data From Data List In Sheet1 Into Sheet2 / Sheet3

Jun 30, 2014

I have attached a sheet that has part of a data list, sheet called (Full Data) what i am trying to do is seperate the data into event locations into individual sheets.

The data ref will be column F which is the different event locations.

I thought the best way to try and do this was to create an if/ match formula using the sheet tab names as the if match, with the event locations in column F.

I have added two sheet tabs so you can see that i require the data for (Ain) to be put into the Ain sheet.

The data list in Full Data sheet will be continuously updated so i will need the range to be around 10,000 entries.

View 5 Replies View Related

Replacing Sheet1 Data With Sheet2 Data For Specific Columns Using Macro

Mar 8, 2014

I have data in sheet 1 like below

Custid loc city
123 us newyork
124 uk wales
876 in mumbai
Sheet 2
custid newcustomerid
123 756
124 394

Outputsheet:
Custid loc city
756 us newyork
394 uk wales
876 in mumbai

So it will check sheet1 custid with sheet2 custid. If both matches it will replace custid with newcustid.if cust id not exists it will load sheet1 recprds as usual.

View 1 Replies View Related

Sheet1 With Two Columns Text Data - How To Get Data Automatically In Sheet2

Apr 14, 2014

I have two column (A and B) text data in worksheet1. If I type same text of column A (of worksheet1) in worksheet 2 column A, how can I retrieve data from worksheet 1 to 2 from same row.

View 1 Replies View Related

Excel 2010 :: Use One Set Statement To Set Second Statement?

Feb 14, 2012

I am attempting to use a previously Set variable as part of the next Set statement, pretty unsuccessfully at present.

My purpose is trying to look up

Code:
tb_SelJobID.Value

from a userform in Col Z then look across the row to Cols D,I,N,S & W (different types of work) to see if

Code:
TbSelYr.Value

matches the year selected then insert a formula in the row to the left. Then loop down to the FinalRow.

Currently my Set Found1 statement does not recognise my Found10 value. I know it will be my syntax as it always is. I have cut down the following code to display where the problem areas are, Found1 thru 5.

Code:

Sub CmdGo3_Click()
Dim Row As Range
Dim FinalRow As Long
Dim Found1, Found2, Found3, Found4, Found5, Found10 As Range
Application.ScreenUpdating = False

[code]....

Windows 7 with Excel 2010

View 9 Replies View Related

Stuck With Array Formula?

Jan 19, 2014

I am using the following array formula "=SUM($I$35:$I$1000*($G$35:$G$1000=$B$10))" which works fine but if there is nothing to sum it returns "0", but I would prefer a blank cell if there is nothing to sum.

View 3 Replies View Related

Stuck In Design Mode?

Apr 29, 2008

For some strange reason the workbook I have been using on a daily basis has suddenly decided to go into design mode and stay there. No matter how many times I click the design mode button in and out it always stays in and I can't use my buttons.....it just selects them?

View 9 Replies View Related

Spooling Data From Sheet1 To Another

Jul 6, 2014

I need to spool data from Sheet1 (Data) such that when the pins are pasted into the combo box and button is clicked it brings up the corresponding reasons and comments for each pin

I have attached a doc. pinpopulate.xlsx‎

View 4 Replies View Related

Getting Run Time Error 91 - Stuck With UserForm

Aug 2, 2014

I'm getting a 'Run Time Error 91' saying that 'Object Variable or With Block not set'.

Error lies here:

Code:
Me.lstCategpry.Column = CustRec.GetRows(Fields:=Array("name"))
Userform Initialize:
Code:
Private Sub UserForm_Initialize()

[Code].....

View 4 Replies View Related

Stuck In Full Screen Mode

Aug 2, 2009

I seem to be stuck in "Full Screen" mode. When I go to the View menu, both "Full Screen" and "Normal" are highlighted. I can't seem to get out of Full Screen.
I am using Excel 2003, XP SP3 installed. This just started this am. I did download and install Microsoft patches this am. ???
I am able to save and use Excel but without normal view my formating buttons etc. are not available.

View 9 Replies View Related

Dde Data Copied From Sheet1 To Sheet2

Aug 28, 2009

I am enlcosing a file that I partially acquired (the macro portion) and I am trying to add to that.

The workbook has a dde link in sheet 1, the macro will write the data to sheet2 at set times. I am creating a report of the data in sheet 2 in sheet3. at this point it is very rudimentary. I need some assistance to clean up the macro and the post of the dat in sheet2. I have created a detailed (probably over detailed) explanantion in sheet 1 in a text box.

View 11 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved