I am trying to create a time tracking sheet that allows me to put in the hour as a number - 0800 and will convert the information to time. IE 08:00 AM

Hi- I have created a lookup table with 12 rows and 28 columns. (I'll call row values "z*" and the column values "A"). In my spreadsheet, z* and A are computed...

Trying to count # of times A occurs with another variable B. i.e. A-1 1 Trying to find a way to count the # of A's when they...

How would I alter a v-lookup formula to recognize specific characters within a field? Example: Data Field has the following 9 characters "R0502AA01”. Can...

Hi, I'm trying to merge together some variable data to some fixed data within Excel but am struggling to come up with an elegant solution to it. I have two...

I am creating worksheet for use where I want to carry on the forumla down the worksheet, even though cells are empty. My formula is =(B6-B5)/ABS(B5) I get...

Hi. I am working on a spreadsheet for work. The problem is i have a vertical list of 4 dates each one 7 days in front of the other (consecutive weeks). Is it...

i know this is probably a really simple thing to do but i am really not familiar with text worksheet functions. anyways i have a cell which contains the...

I have two columns with multiple sets of data, based on the entered value I need the corresponding header returned. For example: Column A Column B Apples...

Let's say I have a string that looks like this C:\Documents and Settings\me\Sheet1 I want to extract the DATE prior to .xls. I can get to this: C:\Documents...

i have some data that is organized terribly, and it's HUGE. i have sales numbers monthly by sales rep the month column has the number of sales for that rep...

A couple of great people here helped me with a minor prob I had on this one & then my boss threw something else into the mix that has me stumped: The scenario...

We have a sales spreadsheet that shows confirmed and projected sales. The projected income from various items is shown in red in our spreadsheet,...

Does anyone know how to average a range of numbers based on a criteria, where the numbers have to fall within a range of data? I have tried combining a number...

Hi, I have a range of stock prices. with indication for buy or sell. and i want a function to calculate the return of the range for example : buy 522.73 buy...

HOW TO DISPLAY NUMBER INTO ENGLISH USING BAHTTEXT() FUNCTION AS IT IS DISPLAYED IN BHAT FORMAT.

"Is there some VBA code with which could I autofill the column B with some formula exactly with the same size in A while this could be variable among the...

I have a table that I am working with where I want to do a =SUM (D5/D3) function and then round up the answer to the next integer. Any help will be appreciated.

I have a list of about 6000 line items. Among other things, the data includes names and email addresses. There are many duplicate entries, checking line by...

I want to creat a formula that will work out the number of weeks between two dates but i can only find formulas for days or months . can anyone help