My data looks as so: Data ColA ColB ColC ColD A 123 Zebra Monkey B 456 Dog Cat C 123 ...

Hi there. I created a validation for a cell by using the "custom" criteria. I then entered my formula into the formula bar. I now need to scroll back and...

Is there a way to do a search in an excel spreadsheet for a specific 'word' and have all pertinent lines deleted? I have a spreadsheet of over 11,000 lines...

I have made a chart in Excel. My boss told me to blackline, or track the changes, when she gave me a revised copy. I am able to track the changes but not print...

Hi there I am working on a spreadsheet to measure agent performance. I want to rank agents on the time they spend in "wrap up" after each call. I've tried...

I have a goal to save $50,000.00 in eight years. My annual interest rate is 6.35%. What amount would I need to put away monthly, to obtain this goal? How would...

I thought this would be easy but still can't get it. How do you get a vlookup to return a value from a column to the left of the array? Thanks -- Brisbane...

Hi, can someone please help. I have employees data regarding hours worked in a decimal format but need to convert this to show hh:mm. So that 3.5 becomes...

I have an existing worksheet with over 50,000 rows and 15 columns. Several columns have information in all uppercase. I need to convert these words into...

I'd like to figure out a clever way to build a dynamic date heading row. I need to enter the first month (1st of the month) and have the following columns all...

Hi! I need some help in coming up with a formula that counts the frequency of something that also matches a particular criteria. I have a list of people and...

in vba what command is used to determine if a particular cell on a particular sheet changed? some kind of event? how to get the old and new value of the cell?

I am a complete newb with VBE in Excel so I ask.... I have a spreadsheet that looks at full load amps for 3 phase motors, valve operators, etc... to determine...

I need to figure out how to automatically assign dynamic range names to each "Saturday to Friday" in a list of monthly day numbers and associated day names...

I was browsing for help on this subject and figured someone might be able to help me here. I have an existing excel spreadsheet that was formed from a...

Hi My users are copy/pasting from cell to cell. This is fouling my data validation. Is there any way to protect he DV and still allow copy/paste? Thanks

Hi All, I have a spreadsheet with 3 named ranges:- File_Name (name of file) Version (file version) Date_Val (date when version was saved). For a given file...

Hello Here's the problem I'm asking help from the more Excel experienced forum users: I have 7 tables with 4 columns: IP, BytesIN, BytesOUT, BytesTOTAL. As...

I am not able to type or make corrections on my Excel Spreadsheet. PLEASE I NEED HELP????? -- Deb

In my worksheet, I have to total several groups of numbers. I select the sum function icon and highlight the field. All worked fine except one, which instead...