General

Highlight duplicates
This code is what I need but how would it be modified to highlight any dups. in Col A that also show up in Col Q too. Mike wrote: slight changePrivate Sub Worksheet_SelectionChange(ByVal Target As 27-Mar-09 slight change Private Sub Worksheet_SelectionChange(ByVal Target As Range) Lastrow = Cells(Rows.Co... 7 Apr 2010 11:14

Multi-select from a dropdown list
I have a dropdown list but wish to select more than one item from it - is this possible? ... 7 Apr 2010 14:40

VLookup Variable Offset
I want to use a macro to set an active cell to return a value from the 2nd column of an array called RollLastRecost. If specific row is empty I want no value to be the result. I have a formula that works if I manually type it in, and copy it down through the other rows but I want the macro to put the formula ... 7 Apr 2010 10:07

Block a excel file from being copied?
I am trying to stop others from saving a file under a different name. Is it possible? ... 7 Apr 2010 13:32

Why would someone use $-sign?
Hi, I am working through a long worksheet with data. It is made for me by someone else. It has about 2300 rows. In Column C are measuring results, Bottom field of this column(C2300) has the median of this column. Column D has for every row the function =(C1-C2300) to measure the difference of that value to the... 7 Apr 2010 08:59

Sum If ???
when I copy an excel file that contains sum if equations many cells in this file are corrupted when they are copied to another computer. can you please tell me a solution for this problem ??? My mail is: ahmed.saad(a)ymail.com Best Regards Ahmed Saad ... 7 Apr 2010 06:47

How do I do a drop down box with calender in excel?
I want a drop down box that shows the current month calender that I can choose a particular date to be inserted into my excel sheet. Any ideas would be great. ... 7 Apr 2010 06:47

Order of Numbers
I am looking to be able to put values in the order of 1 to 5 in a range of cells based on the order of values in another range - as an example the values in range (row) one may be 12,36,25,40,19 which would result in this being shown in the 'order' range as 5,2,3,1,4. Hope this makes sense ... 7 Apr 2010 10:07

Sum and multiply at the same time?
hello, I wonder if anyone can help with the following, I have a colleague who would like to sum and multiply at the same time in a large spreadsheet. He can do this if he types out the whole formula as =sum(a3*a5, b3*b5, etc) but this is extremely laborious for him. If he tries to use =sum(a3*a5:z3*z5) it c... 7 Apr 2010 06:47

Need formula to locate and validate specific text from a strin
Some shorter formula: =IF(ISERR(SEARCH("testing",A1))*ISERR(SEARCH("cold",A1))*ISERR(SEARCH("working",A1))=0,"Yes","No") Micky "JLatham" wrote: Oops, turns out to work better if you use SEARCH instead: =IF(OR(IF(ISERR(SEARCH("testing",A3)),FALSE,TRUE),IF(ISERR(SEARCH("cold",A3)),FALSE,TRUE),IF(ISERR(S... 7 Apr 2010 04:37