excel formuals

This simple thing is eating my brain out. Here is the challenge: I have 2 sheets in the same workbook. Say Sheet 1 and Sheet 2. I want to Vlookup for the value present in Sheet 1 Column A and Sheet 2 column B. If the value is found i want to put a hyperlink in Sheet 1 Column A to point it to...

Dear experts please help I have two column submit date and recived date in excel 2010, I want to put restriction on recivd date coloum. <tbody> submit date recived date <tbody> 16-Feb-13 </tbody> <tbody> 8-May-13 </tbody> <tbody> 6-Nov-13 </tbody> <tbody> 20-Jun-13...

Hi, I am trying to get an average from my SCORE column based on 2 criteria; ignoring all 0s and taking only those values which are equal to my city in C2 cell. Can someone please help fix the below, I just can't get it right. Thanks. =IF(Table1[City]=C2,SUM(Table1[ [SCORE]...

<tbody> date email jan feb mar may jun jul aug sep oct nov dec 1/1 bob@gmail bob@gamail 2/2 eric@gmail eric@gmil 5/5/2014 helpme@excel.com helpme@excel.com </tbody> so what I'm working on is a sheet some what looks like this and Im...

Hello, I have a large amount of data in an excel spreadsheet (over 22K in rows). I imported the spreadsheet into access as a table and made some queries, but the problem is that I'm not sure how to incorporate the much needed excel formulas into the queries to analyze the table. Here is one of...

Dear All, I have a data file in which i have two column, 1st is Expiry Date column in which past, present and future dates are mentioned and 2nd is Status column in which user will mention status either "OK" or "Pending". I need a formula / conditional formatting which will start highlight (...

Hi all, I have been tasked with some string manipulation and today must be my bad head day as it is proving more difficult than I expected. I have to take the initials of the first and second and third name from the first and second and third columns along with any surnames The reason is we...

First and foremost... All credit for these Excel Function Dictionaries/Cheatsheets go to the brilliant <b>Peter Noneley</b>... creator of these magnificent tools... As I hope you all know by now... there exists for each version of Excel... a comprehensive and (very impressive Excel...

Hi Guy & Girls, Have a current situation with an alarms list from DCS system at work output file is .CSV. Each alarm has specific tag and all have priority ratings What I would like is a template type WorkSheet with possibly some code/VBA where by when the alarms list in copied and pasted...

Hi String 1: "bold:yes";color:green;font >12; chart =no, graphic = bad String 2: "bold:yes";color:purple;font >100; chart =no, graphic = bad String 3: "bold:no";font >8; chart =no, graphic = very good;color:brown my question is I want VBA code or excel formula which outputs color:green...

Hi I need a formula to calculate the business hours taken to complete a job. The job runs over a few days but only during business hours. I have calculated the time difference by subtracting the the 2nd date time from the 1st but that gives me total hours, i need just the business hours...

Hello all! So I am trying to rank a column of numerical data by a given average of the cells: Assume, Column "D" is: <table width="86" border="0" cellpadding="0" cellspacing="0"><col style="width: 65pt;" width="86"> <tbody><tr style="height: 12.75pt;" height="17"> <td class="xl22"...