Summary: Hello, Hopefully this is an easy one for someone. I have two columns of alphanumeric data that I want to compare. The data in each column is a list ...
Summary: I want to Highlight Excel Cell by Selecting Different Cell. For example: Highlight cell H3 When Cell A3 is selected. But i need to use this method for...
Summary: Heavy, you need a monthcode(yes or no to sum) and a trigger to autoupdate this monthcode: make a column with: "=IF(C4="auto";IF(D4<=NOW();MONTH(NOW...
Summary: I am working with a spreadsheet on which there is a list of departments who are participating in a certain program. Several departments team up for t...
Summary: I am working with an excel spreadsheet that has dollar values for different companies. i want to get a % difference for each company on multiple line...
Summary: I have a problem, I need to compare data for two columns and a unique value is required. The Problem which I am getting is that I have to compare the ...
Summary: Hi there. I'm hoping someone can help me simplify a function that I'm using in excel. Basically I have rows of data, e.g. Row 1 - XOOXO Row 2 - XXXXO ...
Summary: okay, I have a file in microsoft excel. I have a column in there for a description. However, my resource of all the descriptions are in html files. Al...
Summary: Try This: 1. Insert a column between Column A & Column B 2. Type ( or cut & paste) the following formula in cell B1: =IF(ISERROR(MATCH(A1,$C$1:$C$1...
Summary: Should be a pretty simple question for an Excel guru. I have two columns of text that are nearly identical except a few entries. I need a way to pul...
Summary: I'm pretty sure you can't do this - Excel is a spreadsheet and has references in a cartesian fashion. Access allows you to do this, as it references i...
Summary: Hi. Two problems here. a) I'm seeking an alternative to the Vlookup function to look for a value in the rightmost column of a table. (Not just move th...
Summary: Hi all I’ve already posted this message, so apologies for repeating myself, but I don’t think I explained myself clearly enough the first time! I ...
Summary: Hi, I hope that I have this right! Across the columns is the date, followed by rows for each employee. Under each date there are three options - blank...
Summary: I have an extremely simple Excel spreadsheet that I use to keep track of my running. It's columns are: Date, time to run a mile, time to run 2 miles, ...
Summary: I have a work a spreadsheet that contains several columns for the number of campers, their pets, and vehicles that are checked in every day. What I ne...
Summary: Dear Friends, I have a question in microsoft excel.Suppose i have these cells in my microsoft excel sheet-: A 1 Computers 2 Computers 3 Scanner 4 Keyb...
Summary: Jennifer, try copying this to excel and then copy from excel onto Outlook. For me, gridlines still show even though I change to gridlines off and colo...
Summary: I have a cell on a worksheet named "EDATE". In this cell is a date that corresponds to the date of the end of a week. The data table below contains a ...
Summary: Ok, here is my delima. I am creating a spreadsheet that calculates student grades and averages. Each week I have an average that i calculate for the w...
Summary: Bryan, good guess, I use FoxBase (db3) in DOS. EXCEL exports Column Header Names as field names. Also works in Excel-2000. I have used xbase for a w...
Summary: Excel wont let me sort 2 of my columns because it says they are numbers stored as text! There is a little green triangle in the upper left-hand corne...
Summary: i kinda rushed what i said so i thought i would explain it a bit better. i have made up a pay system is excel that automatically calculates super and ...
Summary: Hi, I am working with Excel and looking for a way to create a Macro to delete specific rows of data that are unnecessary. For example the worksheet co...
![[higher confidence]](http://static.computing.net/img/AT-red_x.gif)
- higher confidence, ![[lower confidence]](http://static.computing.net/img/AT-black_x.gif)
- lower confidence
