Search results

Hello Gurus, Can you please help me with the code? Problem: I would like to shade cells in r2 (A1:B10) with grey color based on value of cells in r1 (C1:D10, empty or non-empty). eg: If C1 is empty, A1 should be shaded grey If D5 is empty, B5 should be shaded grey The code below works but it...

Hello All, I have an Excel table problem. It seems easy to solve but I cannot find a solution. SOURCE TABLE: A Rose A Pen A Pencil B Apple C Cake C Orange C Mango C Lime REQUIRED FORMAT: A Rose Pen Pencil B Apple C Cake Orange Mango Lime GURUS please help. Thanks

Hello XL Gurus, I have a list of IDs in a file and I need a macro to loop through the xls* files in a directory (which has ~100 folders, each folder has ~10 sub folders). Literally there are 1000s of files and each ID is in a folder. To make it faster, I could have the IDs and the Folder Name in...

Hi Gurus, Can you please help me with the following problem. I am new to VBA and do not know how to use variables. I have a sheet (Rawdata) with fingerprints (generated by an assay) for each sample. Each sample has a parent ID linked to it and the fingerprint should match the parent...

Hello Gurus, I am new to excel VBA. I am not familiar with variables and loop, hence trying to use activecell.formula. I know this is not the efficient way to do it, but as I am new and just learning found this easy to do. The following formula works when manually typing in a cell. Formula...

Hello All, I have a macro which updates a file on the server on a daily basis. This is a shared file which many users will access. 1) I would like this file to open as "Read Only" (without prompt) when an end-user accesses it. 2)And I would like the macro to be able to update even if someone...

Hello Ninjas, Can someone please help me? TIA. Say I have a workbook with a worksheet "Report". I have the following UDF which works fine when I have the "Report" worksheet on the same workbook. I would like to modify this UDF to lookup a worksheet ("Range") in another workbook on the...

Hello, Can someone help me with this problem? I have an array, say A 1 2 3 I would like to find the maximum correlation for this array in a database, say B 2 3 4 C 3 4 5 D 1 2 3 E 3 2 1 Is this possible by using excel formula? TIA

Hello All, I need some help with this problem, please. It looks simple but I am clueless how to approach it. Say I have an array 100 25 29 30 18 200 I would like to get the average for this array, but after deleting the outliers 100 and 200. Is there a way I can write-up a formula which...

Hello, Can someone help me extract the Batch # from the following string? "A549_CL130497_SAM602138_Batch100_Plate_5_H4" Answer: 100 The formula that I use, "=(MID($A1,FIND("Batch",$A1)+5,4)*1)". The problem with this formula is that the batch numbers range from 1-1000 and I would like to...

Great site. Newbie using Excel 2010. I have a csv file (>1000000 rows) on the server which updates every morning. I use this file as my source to vlookup and enter information. I have no problems with vlookup (know how to use it) but if I create a macro, it works only when I have the source...