Identify Row Number
Apr 22, 2009I want a function that identify the row number, where the date in column A is the same of the active row, but the value in Column B is equal to a different text e.g.=”zz”?
View 14 Replies
ADVERTISEMENT
Identify Row Number Based On Value In A Cell And Use That Row Number In A Macro
Jan 28, 2009I have Sheet with 40 employees who each proposes their work schedule, so I have to give each Employee access to the same sheet and want highlight and unlock only those cells that specific employee can use.
Each employee has to login from a drop-down (sourced from Sheet.Employee Master), so their unique Employee Number is in "A13" of Sheet.LOGIN
Can I identify the ROW number and then use that ROW number in a macro to highlight and unlock specific Range of Cells in Sheet.PROPOSED SCHEDULE?
---where "Sheet.LOGIN("A13") = (the value in the cell Col A:"row" of Sheet.PROPOSED SCHEDULE)
I have attached a scaled down version of the Workbook.
Following code is scaled down-- this is for Employee 02 who appears on ROW 16 of the sheet. (macro is same for each employee, just uses a different row)
Identify And Number Patterns
Nov 3, 2013A person on this board did this for me with this so far and I need to be able to view more than 16 rows. I would like to view all the rows it finds. I have 62,000 rows on information this far and will exceed 500,000 so you can see my need to see all involved to save hours of sifting through data. I would also like a place up top near the box (column G.H)(3,4,5) another box for me to enter a new number combination to search. Presently I have to go through the data to find the first one which is also time consuming. I would like to be able to put say for example in the area I am mentioning:
2 6
4
2 8
Identify Repeated And Consecutive Number
May 5, 2009E20 with the series of numbers in tenth, and with five numbers on one cell. Between 01-37. How do I write a formula on column R to identify any repeated numbers from E20 with E21? In the chart it shows number 10 is repeated from E21, so I place a check mark on the same row as E20 on column R.
On column S how do I write a formula to identify numbers within E20 to see if there are any consecutive numbers? On E20 there is none, on E21 there is one 10-11, and column S will let me know if there is a consecutive by placing a check mark.
Identify Matches Of Number Combinations
Jan 14, 2008After looking at other similar post titles I could not find a formula to work exactly proper.
I have attatched a sample of my problem. What I need is for cells E4:J4 to look for a match in cells B4:B16 and give a value of " Yes or No " in cell K4 if a match is found. Then copy down formula through E5:J5 to B4:B16 - E9:J9 to B4:B16. As my examples indicate Cells K4 would = yes, K5 = yes, K6 = yes, K7 = no, K8 = no, K9 = yes. Column D is the results, Columns E-J represents all combinations of column D.
I have tried the following formulas but they did not work entirely correct.
= NOT( ISNA( MATCH($b$4:$b$16, e5:j9, 0 ) ) )
= COUNTIF(e9:j9,"="&b4:b16)>0
Identify Number Pattern / Configuration
Jan 21, 2008What I want to do: find the four cell that have the same value "99" in belows configurations
A B C D
1 99
2 99
3 99
4 99
A B C D
1 99
2 99
3 99
4 99
Formula To Identify Week Number Based On Date Ranges And Add Values
Feb 18, 2014I have the following data:
Column A = Date
Column B = Reservations made per day
For ex:
A B
1 3/1/2011 5
2 4/5/2011 10
3 3/8/2011 15
Then I have a look up table where based on the date ranges it assigns a week number.
WeekDATE Range 1Date Range 2
718-Feb-1124-Feb-11
825-Feb-1103-Mar-11
904-Mar-1110-Mar-11
1011-Mar-1117-Mar-11
1118-Mar-1124-Mar-11
1225-Mar-1131-Mar-11
1301-Apr-1107-Apr-11
1408-Apr-1114-Apr-11
1515-Apr-1121-Apr-11
1622-Apr-1128-Apr-11
I am looking for a fomula that would assign a week to the corresponding dates on column A and tha would then add all of the reservations booked for each week.
Identify Duplicates On Sheet 2 And Populate Number Of Duplicates On Sheet 1?
Apr 8, 2014I'm trying to Count duplicate text on sheet 2 and populate the number of times repeated on sheet 1.
On sheet 1 I have A3:A128 and would like the number of times these respective cost centers are repeated in Sheet 2 to populate Column B of Sheet 1.
File attached.
Not sure which formula to use. I tried CountIF but didn't work with 2 sheets.
Identify Changes In A Sheet
Dec 3, 2013I have a worksheet with a large amount of data in it. Every couple of months the data will change and I place this in a different sheet (sheet 2, this comes from a software tool) . Is there's some code that can run a check on sheet 1 compare all values against sheet 2 and highlight the rows that have a different value between sheet 1 and sheet 2? Perhaps paste the rows into sheet 3 with the different value highlighted??
Example of original and changed data attached : example_2.xlsx
How To Identify Cell That DOES NOT Have Certain Value In Its Row
Mar 4, 2014(I cannot attach the files as it is all personal information) Basically its list that looks like this:
2014-02-11 John Doe
2014-02-12 John Doe
2014-02-17 John Doe
2014-02-10 Mary Jane
2014-02-11 Mary Jane
2014-02-16 Mary Jane
2014-02-10 Frank Simms
2014-02-11 Frank Simms
2014-02-18 Frank Simms
2014-02-11 Tony Sly
2014-02-12 Tony Sly
2014-02-17 Tony Sly
Im trying to identify anyone who does not have an entry on 2014-02-17. I've played around with combing IF and VLOOKUP and Conditional formatting but I couldn't seem to get it to work. If it were to find a date, no problem, but to find someone without that date I'm having issues. If there was a way to highlight or identify Mary Jane and Frank Simms since they don't have an entry on 2014-02-17, that would be great.
Identify Duplicates
Nov 9, 2009I have two worksheets one worksheet contains Insurnace names and Addresses from a hospital. I need to match these up to specific Insurance codes from a billing company worksheet. The bad thing is my billing database has multiple duplicate addresses for different insurances (Yes this does happen where different Insurances have the same address-don't ask me why). So originally I did a VLOOKUP where I looked up the address from the hospital Spreadsheet and matched it to the Insurance Specific code. The pitfall to doing it this way is that it only grabs the first exact match from the Billing worksheet. Is there a way to either automatically identify the possible matches and allow me to choose which one is the exact match or how do I just identify duplicates on my billing worksheet and match them manually? I attached the worksheet.
View 9 Replies View RelatedError '91' When Trying To Identify Last Used Row
Oct 2, 2009I'm trying to identify the last used row in Column A of my DestinationSheet so that I can add data to the row below it, but I'm receiving the following error: Run-time error '91': Object variable or With block variable not set And it's directing me to this line of
View 4 Replies View RelatedFormula Identify That A1, B1, C1, D1 Are > B2
Jan 5, 2010I need help with creating a simple formula.
What I have:
..A B C D E
1 3 4 6 5
2 6 2 3 8
I want to identify that A1, B1, C1, D1 are > B2. My formula will be placed in E1 so then I want a value of 1 to show up in cell E1 indicating the identification was successful. I can't figure out how to make this happen. My formulas so far in E1: =sum(A1>B2)&(B1>B2)&(C1>B2)&(D1>B2) This formula comes up with 0FALSEFALSE instead of the value of 1 I am desiring.
What I want:
..A B C D E
1 3 4 6 5 1
2 6 2 3 8
Identify The Opened .xls
Mar 30, 2007I am using ADO connections in my program to insert the datas in the excel. I want to find if the excel is locked by another user. How do i do this in ADO commands.
View 6 Replies View RelatedIdentify Cells Using Particular UDF
Dec 28, 2007I have written a UDF to do some calculations i a workbook. I would like to run a sub, checking the cells in the spreadsheet to see if my formula is present. and if so, then add or change an argument in the formula. My problem is:
How do I write the code so that it will recognize my formula ? Is it possible to attach a tag to a formula which Excel can search for ? I cannot search for the formula including arguments from specific cells, relativ to the formula cell, as the user is free to input the arguments with reference from anywhere in the workbook.
Identify Changes Across 2 Sheets
Jan 24, 2008I am looking for a way to search using macros. Currently i can search/find by cell, but i need to find with mulitple cells. An example is, sheet 1 "A2" and "B3" date needs to be compared to sheet 2 to see if the data is already in sheet 2. Column A is first name and Column B is last name. Need to know if that full name (first and last) is already in second sheet. I can already search for just the first name or just the last name but now the two together.
View 5 Replies View RelatedIdentify Activecell Of A Shape?
May 24, 2014I have put a rectangle shape in a cell in excel. The shape is within the border of a particular cell.
Is there a way to find the reference of the cell on which that particular shape resides.
For example, I have kept a rectangle shape in cell F5. I was looking for a macro which would return the cell reference "F5" in which the shape resides.
Identify Numbers In Sequence
Aug 23, 2007I have a task to identify all the numbers in sequence in a worksheet, how do I do that?
Ex:
Column A
1
2
3
4
5
7
9
10
11
12
13
14
15
16
20
21
22
Desired output 1-5,7,9,10-16,20-22.
Identify And Print The Ones On The List
Jul 12, 2008Have a list of approx. 125 people (for our church's prayer list). What I would like to do is have a formula/macro that will identify and print the ones on the list
-that have been on the list less than 2 months
-identify by printing one "*" by thier name when the 2 months will be up in 2 weeks
-identify by printing two "**" by the name when the person will be removed in one week.
Another way of stating what I am wanting Excel's functions to do is the following:
In one column, I would enter the date a person is added to the list, then I would want the formula/macro to calculate the date the person would be removed from the list. When the list is printed weekly for our bulletin, I would like the program to create the list/print only the persons who have been on the list less than two months. In addition, I would like for the ones that will be removed in 2 weeks to be identified with an asterick when the printing is done. Then 2 astericks when the person would be removed in one week.(This would allert people to update us on the person's condition and continued need for special prayer.)
Of course, I would like this calculation to be done automatically when the data base is opened. OR REQESTED. I'm not sure of my terminology here! I want the calculations to be done without me having to redo the database and formula/macro weekly.
I sure hope this request is clear!
Identify If Value Missed From Lookup
Apr 3, 2009I have a worksheet which records whether a form was filled out in a specific time period . Now I'm down to the last fews bits.... See on the example attached (Sheet is TOP Report) - I have now managed to put formulas in to work out if the TOP was done in a particular time window, however I now need to figure out for each client which windows were missed, e.g on row 7 I can see by looking that the client missed windows 1 and 4, but is there a way to get excel to tell me this without me having to read each line??
View 3 Replies View RelatedDATES: Identify Every Other Friday
Apr 7, 2009I have a column that has dates going vertically down from 1/1/2009 - 1/7/2010. I need a formula that will return the date for every other Friday beginning with the second Friday in January 2009.
View 6 Replies View RelatedIdentify, List, And Sum 2 Columns
Apr 14, 2009It's a time sheet that I need to have whatever data is listed in column E to be listed starting in cell C27 but only once even if it's listed several times. In cell D27 I need the sums to match the data to it's left with the values from above in column D. I've used fill colors to help show my intent. I would also like it to keep track of remaining vacation time by recognizing the word 'VAC' from column E and subtract the value from it's left. This value is shown in cell J26 as '46hrs REMAINING'.
View 4 Replies View RelatedIdentify The Duplicate Values
May 22, 2009i currently have two columns (e.g. A2:A400, B2:B20) and i am trying to match all the values in B to A, displaying TRUE or FALSE (if the values from B don't appear in A) in column C.
i have tried using the various formula for duplicates, substituting what i thought would be the correct formula, but to no avail.
Identify Milestone Anniversaries
Nov 18, 2009I am trying to identify milestone anniversaries of 1,5,10,15,20,25,30,35,40 and over 40 from the date an employee joined the Company but only between the dates of 1st July 2009 to 30th June 2010. It's the split year part that I am having trouble with.
View 6 Replies View RelatedIdentify Every Weekend By Placing 'X'
Jan 8, 2010If I have 1 Jan thru 31 Dec in A1 - A365, is there a way I can identify every weekend by placing 'X' in Col B alongside every occurrence of Saturday and Sunday?
View 2 Replies View RelatedFormula To Identify A Sequence?
Nov 29, 2012 formula that will produce the number sequence as shown in the third column of the table. The sequence starts at 1 and if the colour changes then the number is 2 and if the colour changes again then the number is 3 and so on. The part I'm having difficulty with is that if the name in the first column changes then the sequence must reset to the number 1 and become 2,3 etc. as above when the colour changes.
Peter
Blue
1
Peter
Blue
1
[Code]....
Identify All Consecutive Intervals
Sep 18, 2013Is there a formula that can identify all the consecutive intervals that have value below 90%.
View 1 Replies View RelatedHow To Identify Colored Cell
May 18, 2014I have a table with numbers, I want to create a result column according to colored scores. How can i do it with a macro?
See attachment for details : score.xls
Identify Missing Numbers
May 26, 2008this is exactly what i am looking for also, can you please explain how i can use that code in 2007? I have attached a list of the numbers i'm working with, please can you have a look for me?
I've tried entering it ion visual basic but i keep getting:
COMPILE ERROR
INVALID OUTSIDE PROCEDURE
Identify A Specific Computer
Sep 9, 2009I have few macros that I use to reconfigure a particular workbook into a sort of "developer mode". I keep them in a text file that I can paste them from when I'm working on it and then delete them before I send it out to other people.
I'd like to be able to script them so they only run if the workbook is open on a specific machine (namely mine). Is there any way to identify the specific computer a spreadsheet is being run on?