Finding Intersecting Row And Column On Chart Based On Data Input
Feb 22, 2014
In my table I want to create a user form where the individual would enter a number which would correspond for the Header Row.
and
The user would also enter a Number that would correspond for the first main column (Column B).
Based on the numbers entered, I want to find the next highest number.
For example if 61 is entered 66 would be chosen.
-Same would be for the numbers entered to find the column.
Based on the numbers entered I would like to find the intersecting cell.
Basic code I can embed in a user form?
View 1 Replies
ADVERTISEMENT
May 10, 2008
I would like to find the intersection points of all of the linesshown on the included chart. If that could be output into a table, by the day, that would be ultimately what I am after. http://bladeseri.50megs.com/Intersects.png. Guess 50megs.com doesn't allow this type of reference. Here is Geocities link http://www.geocities.com/bladex2007/Intersects.png
View 5 Replies
View Related
Jun 15, 2006
I have a main soure data which consist of row & column information. What i want to do is search the data from the source data into my result data as per the attachment file. Example: I want to information of Jan & banana from the main source file to appear in the XXXX
Result data(criteria base on Month & type)
JanApril
BananaXXXX
Apple
Orange
View 4 Replies
View Related
Jul 30, 2014
I have a table of data which I would like to filter based on a manual cell input instead of the autofilter option.
The table has tickers in column B and has information from column B to U. I would like to filter the data based on a manual ticker that I enter.
View 6 Replies
View Related
Aug 22, 2014
I do data entry for a driveway company. I get addresses and phone numbers, and then call the people to offer services. I keep track of my calls on the spreadsheet, color coded for my results, green for leads, yellow for voicemail/no answer, and red for not interested.
I have formulas in cells M2 through M8 to give me my overall stats for the calls I have made, it filters them by color for leads, missed calls, and rejections, and a couple other stats (mostly for my own curiosity)
What I'm trying to add is the cells L10 to M13, I want to be able to input a date, for instance 8/15, and have it run the same stats, just for that day essentially. So, I need it to search the last 2 columns in the table for the text that I input into cell M10, and then run the color based formula on those cells, and total them up in the appropriate cells, M11, M12, and M13.
The 2 Stats tables are the same at the moment in the sample, as I only included one particular street that I have mapped, my actual table is nearly 3000 rows.
View 3 Replies
View Related
Jan 23, 2008
I have a list of items in a tab of a workbook that has attributes across the top, with an X in the intersection if the item has that attribute. For example:
Items:
Apple
Table
Paperclip
Attributes:
Red
Wood
Small
The Apple might have an "X" in the intersection of Red and Small, and the Table might only have an "X" in the intsersection with Wood.
I have another tab with five drop downs that can either be blank, or one of the attributes. I want to create a formula that will return the number of items in the list that have an "X" for all the attributes selected in the drop down. Therefore if I selected only "Small" and left the other four blank, the formula might return 2, and if I then select the next drop down and select "Red" the formula would now return 1.
Any thoughts of how I could accomplish this? I am thinking of using a SUMPRODUCT and some sort of Index Match to find the value in the cells selected by the drop down. It seems like Index only returns a row though, and not a column.
View 9 Replies
View Related
Dec 19, 2009
# STUDENTS THAT GOT 100% IN EACH SUBJECT IN EACH SCHOOLKKVRockfortCampionENGLISH232013MATHS382518PHYSICS422515CHEMISTRY483020BIOLOGY503523
Consider the above table. Ca someone help me understand how to report the value of the # of students that got 100% (output) in a given school (input 1), and given subject (input 2).
In other words, if the inputs are the following:
Input Cell 1: Rockfort
Input Cell 2: Pysics
Then, Output Cell should report: 25
I know one option is to use the INDEX function, but with index function, I have to provide Row_Num & Col_Num as inputs. That doesn't fit my example above, as my inputs are specific values from the leading row and the leading column of the array in question.
View 9 Replies
View Related
May 9, 2007
I have a sheet(A) that I input items into cells B19:B49. Sometimes cells are left blank because there's no data to input. In cells A19:A49 I use to input remarks regarding what was put into it's adjacent cell.(B19:B49)
On a seperate sheet(B) I've labeled colums with items that I input into the cells B19:B49 on sheet(A)
let's say I title a column "Toys" and a row "Aisle 1". Where these intersect I want to display the information from sheet(A)'s remarks section cells A19:A49.
View 9 Replies
View Related
Dec 31, 2006
The formula should take the info from validation lists in R13 & S13, and match them up in F3:O3 (T1Q2) & C6:C15 (T2Q2) and return the data in the intersecting cell into R9 (Where the formula is kept). In this instance, it should find 1 at I3 and the 4 at C15 and return NN to box R9.
View 10 Replies
View Related
Jul 24, 2009
I'm looping through and finding a cell based on Column A, and I .resize(,5).select and from that selection I want to create a range called "LCrng"
View 9 Replies
View Related
Nov 7, 2008
This should be simple to do but I can't figure it out. I have a database that lists operating room numbers in one column and the length of the surgeries performed in those rooms in another column.
I need a formula that will give me the longest OR time for a given room. For example the room numbers are in column A and the OR times are in Column B. I've tried something like
View 6 Replies
View Related
Aug 27, 2013
I am attempting to update a column of numeric values based on finding and validating record IDs in two different worksheets. So for example if in worksheet1 in column 'C' the ID is 1234ETC and in worksheet2 1234ETC is found then I want to update worksheet2 in the corresponding cell for that record ID in column 'J' with the information from worksheet 1. So far I have been using a routine like the following to go through and compare the ID's but now I need to update the other cells in column 'J' reveiw the following and see if there is a way to improve upon this.
Sub UpdateCommitmentAmtsFromImport()
Application.ScreenUpdating = False
Dim bottomC1 As Integer
[Code]....
View 1 Replies
View Related
Apr 24, 2014
I have 2 columns of data in Excel which I have brought a small section of it below. As can be seen the values in the left column have a large spike (difference of more than 10) at certain points (in this case at 34). I wan to find the average of the numbers in the right column but only till the point where the large spike happens (in this case the average of the first 5 numbers). I've tried AVERAGEIF but it's not what I want. I want this to repeat for the entire column and give me the averages of each of these groups.
10
32.4
11
38.6
12.5
23
[Code] .........
View 2 Replies
View Related
Mar 12, 2009
This has to be easier than I am making it out to be!
I have column C as my selection column...so basically if they would like to see any items in rows 7-60, they can put an X in Column C and see an aggregate of those items.
What formula would I use to do the aggregate that is determined by input into column c?
View 8 Replies
View Related
Jan 2, 2013
This formula allows me to find the lowest value in column U where column N contains the text "NO".
{=MIN(IF($N$2:$N$10000="NO",$U$2:$U$10000))}
I want to add another condition so that the formula only returns the lowest value in column U where (i) column N contains the text "NO" and also (ii) column F contains the text "YES".
View 11 Replies
View Related
Mar 26, 2014
Creating a working userform that takes data input from the user and puts it onto a spread sheet.
That data is then used to calculate a result (via the spreadsheet), and I want that result to show on the userform when the data is submitted (if that makes sense?)
View 1 Replies
View Related
Dec 29, 2008
I have a table (Sheet 1) with four columns data, A,B,C and D. There are about 60,000 entries in them. In Sheet 2, I wish to enter a value in A1 which will be from A OR C columns of Sheet1 and get its corresponding value from B or D (Sheet1) in B1 (Sheet2) with the help of a formula. i.e. IF(A1, Sheet1!A60000:C60000, then B1 = B or D of Sheet1).
View 2 Replies
View Related
Oct 20, 2009
I have the following code. Is there any way to select a range once the last cell with data is found. I would like to be able to select whatever cell in column A is selected with the code below through E2.
View 4 Replies
View Related
Jan 20, 2010
Example attachment is included. The goal of this is to extract data off of another sheet based upon an input value. It's easy enough to where the input value will be equivalent to the sheet name I want to reference. The example I provide incorporates code that works successfully. The only problems I have are:
1. The select method only works on the active sheet. I want to be able to call this while another sheet is active.
2. My code is very inefficient and takes a while to execute. I'd like to cut down on the execution time.
View 2 Replies
View Related
Jun 14, 2006
I am trying to move (archive) data from one sheet to another sheet based on a date range provided by the user’s input. If the date on sheet “list” in the cells in range R9:R10000 fall within that date range the following takes place. The rows that meet the date range per the user’s input in the range of R9:R1000 are copied and just the values are pasted into the next empty row starting with row 7 on the “report” worksheet. The cells that are copied on the “List” worksheet are NOT deleted but the contents are cleared. The reason for this is because there are formulas/links in those cells.
I have attached a worksheet example and have some VBA code but it does not work.
View 9 Replies
View Related
Jan 6, 2009
Is it possible to have a marco that will look at the data in a cell/multiple cells and search a network drive for a folder named with the same data in a cell? For example, I used a marco to create a folder from the contents in cell A2. Can a macro be reversed in that if I have a spreadsheet with a list of data in A2,A3, A4 and so on, can it check a network drive to see if a folder has been created with the same data?
View 10 Replies
View Related
Jun 6, 2013
Any way to search for a value down column A, another value across roW 1, and tells what value lies in the cell at their meeting point. 4 example, I'm looking For "47" somewhere in column a, and also the number 53 somewhere in row 1, and I need to know what value is in the cell where those to meet.
View 1 Replies
View Related
Oct 22, 2013
I have a form with a number of fields. There is a field at the top of the form for Part number. When I type in a part number I need the form to auto complete any fields that are linked (if i can link them). E.g., if the part number is 111 then based on info in another table the fields will be auto completed for me.
View 2 Replies
View Related
Mar 21, 2014
I have a spreadsheet where the start date is manually entered in Cell B1 and an end date is calculated in Cell B3. I would like to have the dates between the start and end date, with a step value of 7 days show in the rows under Cell B3. How do I get this to work?
View 3 Replies
View Related
Dec 22, 2009
Excel 2003, I have a list of products with corresponding prices located on a hidden worksheet. I have a spot on another worksheet where users can select a certain product and next to that cell there is a column for price. What I want excel to do is auto-populate the price cell based on what product the user selects. For instance, if the user selects OD2000N, then I want the price to auto-populate with the corresponding price that is found on the hidden sheet. Like I said before, I know this has probably been answered, maybe even mulitple times but I can't seem to find the appropriate thread.
View 9 Replies
View Related
Jul 18, 2009
Here is my delimma. I am using the standard InputBox for my users to input the number of errors found for each category in a record from a daily report. The problem I having is that every time the user types in data using the InputBox it overwrites the previous days numbers. I need to set up the InputBox code so that after the user has input the numbers for that day that the next time the InputBox is used it selects the next column to the right and continues to do this for each day.
View 4 Replies
View Related
Jun 16, 2014
Any quick way to extract data from a table. I need to extract a value from a column that meets criteria from two different columns. I thought I could get this to work with vlookup, but have had no success. Sample data below in table 1 and I would like to get my data into table 2.
elevation
type
grade
percent
weight
5000
5000
5000
5020
[Code] ..........
View 9 Replies
View Related
May 9, 2012
I have a userform that has Label 1, textbox1 and textbox2 at the top. (I shall call it HEADER)
Then, arranged in a row i have combobox1, textbox4, textbox6, textbox7 and label7 (I shall call LINE1)
On a row beneath this i have combobox2, textbox12, textbox14, textbox15 and label 10 (I shall call LINE2)
I need a way of finding the first empty row on sheet 1 (easy bit) and then putting the info from the HEADER and LINE1 in the first empty row, then HEADER and LINE2 in the next empty row etc etc. There are 5 rows in total
View 7 Replies
View Related
Apr 14, 2014
I need to copy and paste the specific dates from the specific city that the user will insert in the "dash" sheet.
Basically, I need the macro to read the city and range of dates that the user will type into the "dash" sheet and copy the columns "AA" to "AD" from rows specified by the dates input. Once it has been copied, it has to be special pasted just the value onto the sheet "1" beginning at location B2.
the the data will not be available as it is vlookups to another excel sheet that i have not provided. I have deleted the data, but you can pretty much put 1's everywhere.
View 11 Replies
View Related
Dec 4, 2009
I have lot of data in three columns like this. The first column is "Name", the second is "Comment" wherein I want the macro to write some comment, the third one is DOB. The problem is that the names in column 1 repeats many times. I want a macro to write in column B "either Old or Older or Oldest" based on the Name and DOB. Thus David with DOB 13 Sep 1982 be marked Oldest in Column B and David with DOB 25 Aug 1988 be marked Older and David with DOB 24 May 1990 be marked Old. Similarly William and Rita should be marked either old or older or oldest. As the data are enormous I do not want to refer the actual name in the programming. I want to call them using a variable in programming.
NameComment DOB
David 25 August 1988
David 13 September 1982
David 24 May 1990
William 24 March 1980
William 25 July 1987
William 13 August 1989
Rita 17 July 1990
Rita 24 April 1989
Rita 13 June 1988
The example file is attached
View 14 Replies
View Related
