Find And Mark
Mar 16, 2009
I have to manually enter the code nos. of the hard copy to find the code in the soft copy. After finding the number, I wish to mark it as so that double work should not be done or to find which code's hard copy is not with me.
I am using Find and Replace to find the number and after it is found I have to click the replace tab to enter colour in it.
Is there any auto function to mark as soon as I find the required number instead of clicking the replace tab to save my time.
View 9 Replies
ADVERTISEMENT
Dec 16, 2008
I need to find duplicates subnet information in row F and mark the words "Duplicate"
Then I need to do the same with Row K. I need to find any duplicate subnet masks.
The reason for this is that I merged two orginizations into one spreadsheet and I need to find the duplicates in Company A and Company B's subnet and mask information.
View 9 Replies
View Related
Feb 15, 2010
look at the attached file. This might be the perfect job for a macro. I am trying to find the SKU's from sheet 1 in sheet 2 and subsequently mark the matching SKUs in sheet 2. Ideally, I would like the SKU's that could not be found to be set to Quantity "0"
View 2 Replies
View Related
May 8, 2008
How do you find if the last character in a string is a quotation mark?
View 9 Replies
View Related
Mar 19, 2009
I have a approx. 70 excel sheets with thousands of entries. Within a single sheet there are some duplicate entries (based on an account number). I find the duplicate entries by using the excel 2007 conditional formating and then sort by color to only show the duplicate entries. There are often hundreds of accounts that are duplicates. Sometimes there are more than 2 identical account duplicates (could be 3,4 or more). In each entry there is a number representing the rating of said account. These numbers differ within the duplicates. Example............
I am trying to find a formula that will choose a "winner" and enter a "W" based on the highest rating within the duplicate entries and then ideally assign an "L" to the loser duplicate account(s). Sometimes there is no rating, other times the rating could be the same in which case any account (does not matter) can be assigned a "W" and the others an "L"
View 3 Replies
View Related
Oct 16, 2013
I have big library books database file. now i want to re check all the book with physical stock and mark in excel file.
i have one more file with books barcode no.
now i want to mark multiple cell in sheet..
View 3 Replies
View Related
Mar 17, 2009
I'm trying to make a macro, which search for a cell value of "Year". And from that cell, I want to make a range selection down to the first empty cell in row B or the first cell value with "Contracts of difference".
See the attached document I want to mark row 50 to row 55, and Column A to K. However as this range is in different rows each time, I need to make the selection dynamic. And I belive the heading "Year" is the best reference point.
View 2 Replies
View Related
Oct 1, 2007
i have a project and i am making a spreadsheet for a make believe green grocers. i have a retail price and a whole sale price
to work out the retail price i need to sue this forumula
retail price = wholesaleprice + x% of wholesale price
im stuck, what i have done is declared the percent value on the page, which can be changed at any time, how do i then substitue this value in to the formula (and most importantly, what is the formula!)
View 10 Replies
View Related
Feb 26, 2009
how and where to navigate on the website to mark all my posts solved. Sometimes I don't see the edit button, I don't know how to list all my posts, etc.
View 5 Replies
View Related
Jul 22, 2014
I have two workbooks, lets say book1 and book2
In column A of book 1 i have a list of numbers, going down to A250
A1 = 23423423
A2 = 23442345
etc etc
I would like some code for a button press, if the value in A1:A250 is in book2 (A1:A250)
Both workbooks will be open at the point of the button press
then adjacent cell in B1:B250 is marked as Yes
View 5 Replies
View Related
May 23, 2008
I've searched for this in the forums but can't find anything. I need to find/replace a character in Excel, it's a question mark in a box and looks like this
I've tried searching for special characters (using the ALT key and number pad) but I can't find anything matching this.
When I save the spreadsheet as a CSV (TAB delimited) this character gets picked up as a TAB, but when I try find replace on the TAB character it doesn't work!
I'm using Excel 2007.
View 9 Replies
View Related
Feb 2, 2014
I have the following formula and need to incorporate that it is only a "B" if B20 also matches in named range "Breakdown_RSC"
Formula: ...........
I need the following section to take into account the data in B20 as in if it matches the data in the cell it should be a "B" in the cell.
View 2 Replies
View Related
Mar 3, 2014
I am making a rough gantt chart in excel for a project schedule. Japanese at work love excel fro some reason that is why I am trying to do this. I have column headings for days ( 3/3, 3/4, 3/5, etc) and I want to find a way to mark the intersection when a date is input in another row. I tried to do some conditional formatting using symbols, but couldn't get anything to work.
see picture. I want to mark at correct date according to column headings when date is placed in column E or F. This example shows column E with 3/10 so I want to make a value appear at intersection AS and the row 3/10 is on. Would like to get a symbol to appear there if possible.
excel help.png
View 5 Replies
View Related
Dec 18, 2008
Is there a way to set a cell so if you click it, an "X" will be in the cell and if you click it again it will clear? Specifically I am looking to do this in the "1st Trip" column on the attached. I was going to use a check box but the appear to small and it does seems as though in Excel 2003 the size can be adjusted?
View 11 Replies
View Related
Feb 13, 2009
how do i mark a thread closed? I looked in tools and lots of other places?
View 4 Replies
View Related
Nov 22, 2009
i want to know how to mark the cells with color where the starting date is not greater than ending date.
View 4 Replies
View Related
Dec 27, 2008
I have a list of energy consumption records by address. The utility that supplied the data had to manually pull each record one by one from their 'database'. If two individuals shared one account, the record is repeated.
So, I have a 500,000 row table with some records with identical addresses and identical consumption amounts. How would I go about separating the duplicates (to then delete them)?
It's sorted by address then consumption. The logic is...
if the address value in column A repeats and the consumption field in column B also repeats, then...(place a marker in column C so I can sort and delete)
View 2 Replies
View Related
Sep 26, 2007
set up a cost based markup spreadsheet?
I need to be able to mark up values from 0.01-9.99 by 20% of their value, and 10.00 and above by 10% of their value.
I only know how to mark up values by a single percentage.
View 9 Replies
View Related
Aug 14, 2009
I have a problem - I wanna to mark (to colour) just cells which I use in formula is there any option for thise
If I have some table and I have formula =A1+B5+C7 I wana to colour just mentioned cells
View 9 Replies
View Related
Aug 24, 2009
I have a simple spread sheet, as shown below. Each line is on it's own row, and all the info on each line is in the first cell. (A1,A2,A3 etc....) What I require is a macro that will look at the "Code" line, take note of the code and if it finds a duplicate code number, mark the duplicate code with (1)....say up to (5).
In the case below, it would flag the second 07edr code and change it to 07edr(1). If there was a third 07edr code it would mark it 07edr(2) etc.
It needs to look at all the codes as it's possible there will be more then one set of duplicates.
Description = item 1
Code = 07edr
Quantity = 1
Description = item 3
Code = 08geo
Quantity = 2
Description = item 78
Code = 08cpm
Quantity = 1
Description = item 1
Code = 07edr
Quantity = 2
Description = item 39
Code = 16blf
Quantity = 1
View 9 Replies
View Related
Aug 22, 2007
I inserted a check mark and tried to us a vertical lookup and post the check mark
All I get is a horseshoe looking character. When I do reference to the cell I get the same symbol. What I trying to do is to place a check mark by the items which have been approved. I know I could do it with an "X" or a color, but top management wants a check symbol. I am using Excel 2007
View 3 Replies
View Related
Aug 15, 2014
I have about 50 timespans.
Each is formatted to have start time in column A and end time in column B (DD/MM/YY h:mm).
I also have a list, with about 850 rows timestamped (same format).
I need to mark all rows which fall in one of the ranges.
View 2 Replies
View Related
Jul 17, 2014
I am creating a resource and I'd like the users of this resource to be able to click a cell which will then automatically come up with an x or similar symbol (tick?) and then if they click the cell again the x will disappear. Is this possible? I don't want a drop down box where they have to choose what they want, I want it to be an automatic action when the cell is clicked because there will be many cells that I will need to do this.
View 14 Replies
View Related
Dec 18, 2008
i have a excel file i need to markup by a 10% value. It is the L column starting at row 2 till a varying number of rows. i need to mark up all of the rows in the spreadsheet. i do not know how to make it repeat.
This is the formula =L2*1.1(i think its the right one) but i do not understand how to make it repeat. any help would be greatly appreciated.
I need the value to be replaced with the marked up value.
View 8 Replies
View Related
Jan 28, 2013
i have two entries in my excel sheet which i want to get noted in the other cell as follow
A B
1 ORDER NO. 480
2 GOODS 5
3 P.M 480X5
as my table have data in B1 AND B2 so i want B3 automatically becomes 480X5 so how can i do it
View 2 Replies
View Related
Oct 30, 2013
When comparing collumns to find out if the values are the same or different I use this formula:
=IF((A2)=(B2);"same";"different")In some cases I see the results are not OK. I see the same values but the result states "different". This might be caused by spaces around the value that does not exist in the other cell I think.
File is attached, the green marking show what I expect to see, the yellow marking shows what puzzles me.
View 11 Replies
View Related
Nov 13, 2008
I need to click on a cell and when I click on it, it should change colour and insert a tick (or other symbol).
View 14 Replies
View Related
Mar 14, 2008
Want to make an if rule where a student gets overall 75% in a column, then in another column next to that that would automatically give him a B or a B+ you know what I mean?
Hear are the ratios
A+ - 90-100
A - 80-89
B+ - 75-79
B - 70-74
C+ - 65-69
C - 60-64
D+ - 55-59
D - 50-54
E+ - 45-49
E - 40-44
and another one
Excellent - 80-100
Very Good - 70-79
Good - 60-69
Moderate - 50-59
Borderline - 40-49
View 11 Replies
View Related
Jan 21, 2013
was wondering if it was possible to mark a text or cell as red every time a subtraction was made and also to show the total cell or text as red whenever a link is made ?
View 3 Replies
View Related
Apr 18, 2014
how to make upper case after mark "." (dot), see this below :
sample data
after formula
Tabrani,Ny.yusmaniar
Tabrani,Ny.Yusmaniar
Badu Zai,Tn.surjaah R & Darussamin
Badu Zai,Tn.Surjaah R & Darussamin
Zainal Arifin,Ny.elvyati
Zainal Arifin,Ny.Elvyati
etc..
it's possible with excel code? if could perhaps not macro.
View 5 Replies
View Related
