I have two formulas that I want to create. I have data from an assembly equipment tester that has the following columns A B C ...

I want to put a line break at a specific place, not only at the end of the line (the width of the column is given) Thanks & regards Albert

Does anyone know how to sort in gigikey style? Example: 1,10,11,12,13,14,15,16,17,18,19,2,20,21,22,23,24,25,26,27,28,29,3,30,31,4,5,6,7,8,9, It needs to sort...

I have a seperat workbook for each of my clients with the clientno as the filename i.e. 1001.xlsm, 1002.xlsm etc. All these files are in lets say c:/docs....

Hi I need to calculate the time worked for the employees on a weekly and monthly basis, but knowing all employees they are not always at work. So we use...

I need to calculate hours worked for the employees. The staff reg got the moths dates in row 1, and "time in" and "time out" in row 2. Column A is for all...

Can you please show me how to set up a simple variable in Excel, but this variable must be cell location independent. Because this worksheet will be sorted...

Instead of carefully going down the worksheet and trying to identify where I have previously hidden rows, is there a way to have a small + button on the side...

Hi. I have weekly data by Contract number over multiple worksheets. I want to sum the hours associated with the contract. The contract information will not...

While updating my Access database with information from an excel file, I have lost my place where I was in updating. I have exported my Access list into a...

Good day. I have multiple worksheets in my workbook. I want to sum the worksheets by the column called Contract, by quarter. I have made a quarterly...

Hi there I've been trying to use =DATEDIF(A1,TODAY(),"y") - A1 being my date of birth, but when I activate the formel I get an error - high-lighting both the...

Hello , i am new excel user (excuse me for that...) I am trying to have more than 3 colors conditions in one data sheet The idea to give every group one...

Hi everyone - hope someone can help me I created multiple sheets with the same formulas, now i need a report sheet to collect information from these...

Hi Everyone, I have a problem in Microsoft Excel and I hope someone will find a solution for me. In cell A1 I have =Today() in cell B1 I have a code that...

Is there any formula which can give cell address of occurence of a vlookup formula. Thxs

I have a table with region, leaders (rows), points per leader (value), and date (column). I want to get the average number of points per region per day....

I have a list with task codes and a "points" value associated to each code, for a number of people, for every day of the month. People is split in several...

I have an application that exports data in CSV fromat to my Desktop or wherever I want. When I open it, I want it to be formatted already (columns, rows,...

I have noticed that after selecting A4 paper, the units in page setup/margins changed from inches to metric units. I would like to know how the get...