Functions
in [Excel]
|
Conditional Formatting Question with 'OR' Is "OR" operator allowed in Excel conditional formatting? If so is there something wrong with this formula - it does not seem to be working? =OR(TRIM(K3)="PENDING","INACTIVE") ... 21 Apr 2010 13:37
Excel 2007 Page Break Adjustments causes a page break each cell Win 7, Excel 2007. When we look at a document in page break view and then drag the page breaks to make the doucment fit on a page, the document will put a page break on each cell. It does not happen each time and a reboot does not fix. Deleting excel.exe helped as stated out on the Internet but this problem... 21 Apr 2010 10:31
Search Macro - Command Button How can I do this using the Command Button? "Jacob Skaria" wrote: Try the below...If you are looking for a whole cell match; then change LookAt to xlWhole Sub Macro() Dim varFound As Variant, varSearch As Variant varSearch = InputBox("Find string") Set varFound = Cells.Find(varSearch... 21 Apr 2010 10:31
Help with Date Function I have tried, and I can't figure out if this is possible. I'm trying to have dates autofill into a row of columns (C5 to V5 to be specific). I don't want week-end days to be a part of the autofill, and I can't figure out the formula. Any suggestions? ... 21 Apr 2010 12:35
Search Macro Is there a macro of function I can use to find key words or statements on a worksheet, similat to the Find (goggles) icon? Many thanks. ... 21 Apr 2010 07:24
Counting values in an array where value in one column is not null Hi, I am collating project details from multiple sources and need to report back how many projects are active in specific phases based on data such as in the table below: Projects Phase Version "Start Date W/c" "End Date W/c" A Prep Build Deliver a1 5-Apr 26-Apr Close a1 26-Apr 26-Jul B Prep ... 21 Apr 2010 07:24
Range Vlookup Hi Every One, I hope you all are doing well, I required your help to resolve my issue in excel. On single worksheet i have two different sheet name as 1.IP Range 2. Result. Question: EG:IP Range Start IP End IP Area 192.168.1.4 195.182.254.254 AG 10.15.33.10 10.18... 21 Apr 2010 08:26
Return cell characters after space I have a cell with 'Mr J. Smith' and want to return in another cell 'Smith'. As there are many other examples, I need a function that will seek out the last ' ' in the cell content and then return all characters to the right hand-side of this ' '. e.g. 'Mr K Peters' would return 'Peters' Please let me know ... 21 Apr 2010 06:22
comparing more then one column with numbers and letters I have 6 columns and many rows in a spreadsheet i want to create a formula that looks at two common columns and if the same replace a column with an amount from another column. Below is sort of an example of what I mean: column a column b column c column d column e column f acc50138 ACCCS20-1 ... 20 Apr 2010 19:42
combining columns and using concatenate I would greatly appreciate your time in looking at this. I have 2 questions. The first is: I have 2 columns A and B. Many of the cells are blank in column B. When column B has information in it, I want it to replace the information in Col A with the information from Col B-if col B is blank, then keep the ... 20 Apr 2010 20:48 |