The discussions

Trying to add a value if a test result is positive or negative

Hello, I have been asked to build a spreadsheet to calculate patients follow up depending on their blood test result. I will only know if the ...

1 reply Last reply on 15 Jan 2015 by
vcoolio

Excel query urgent please.

 Solved

Hello, I have the below data in sheet 1, where as in column A its the activity and column b its the name of person who has done it. and the names ...

11 replies Last reply on 15 Jan 2015 by
wasey

Is there a formula for this issue? thank you in advance

Hello, Please help, the issue goes like this, I want to find a NAME within a RANGE of CELLS and the result would be the LATEST DATE they have i...

1 reply Last reply on 14 Jan 2015 by
RayH

Excel list item automatically generates a new list

Hi! Hoping someone can help ;D In Cell A1 there is a list called "clothing" (a drop down box). In the list you can choose "T-shirt" or "Sweats...

1 reply Last reply on 14 Jan 2015 by
RayH

Conditional formatting comparing dates

I have two columns, that each have dates in them. I want to take Column A, subtract 100 days, then compare it to Column B. If Column B is less than C...

1 reply Last reply on 14 Jan 2015 by
RayH

Auto filter based on cell value

Hello, I have a huge database and ever growing. I need to filter based on a cell value Summary!C2 this value is selected from a drop down list....

3 replies Last reply on 13 Jan 2015 by
IzakG

Calculation of number of months

Hello, number of months between 1/7/2013 and 26/1/2015 Configuration: Mac OS X Lion (10.7.5) / Chrome 39.0.2171.95

1 reply Last reply on 13 Jan 2015 by
RayH

Excel file do not open normally.

I have Office 2010 and Windows 7. I have one Excel file which has very abnormal behavior. First I opened it, drafted it a little, then closed. Next da...

1 reply Last reply on 13 Jan 2015 by
kieferschild

Trying to set up a payroll system for 1 or 2 casual employees

I'm trying to set up a payroll system for 1 or 2 casual employees. Most forums recommend a manual system. Can excel add up a year to date column acros...

1 reply Last reply on 13 Jan 2015 by
vcoolio

Copy select columns from a row given a criteria was met

I have been working for quite a while on a spread sheet for a productivity tracker. I have tried to copy and past several codes and editing them, but ...

1 reply Last reply on 13 Jan 2015 by
vcoolio

2 list matching

i have 2 lists: LIST 1 A1 B1 sku1 4.50 sku2 5.00 sku3 6.50 sku4 2.25 sku5 1.25 need to enter/match these B1 values into a similar, but n...

1 reply Last reply on 13 Jan 2015 by
venkat1926

Want cells to show e.g. £100.00 when there is a value

Hello, I'm using Excel 2007 and I want cells to show e.g. £100.00 when there is a value but when there is no value I want the cell to show nothing...

1 reply Last reply on 12 Jan 2015 by
RayH

Time differentials

HELP!!! I have 4 columns and need to figure out the hour differentials Column A has a Date (1/3/15) Column B has a Time (9:00am) then Column...

5 replies Last reply on 12 Jan 2015 by
RayH

Vba to copy/paste rows by client name to different spreadsheet

Afternoon, I am new at VBA programming. I have tried sub copyrange and if/then with limited success. I have a master worksheet and individual work...

1 reply Last reply on 11 Jan 2015 by
vcoolio

Data transffering

Good Morning. I am new to the forum thing so any help would be great. I am not sure if this is possible but I am looking to see if I can automatical...

2 replies Last reply on 10 Jan 2015 by
vcoolio

Copy values from a table to another tab

Hello, I have an excel spreadsheet. How can I copy values from a table to another tab by placing an "x" in the right column. I only want th...

1 reply Last reply on 10 Jan 2015 by
vcoolio

Get max value

Col A Col B Col C Row 1 A A 110 Row 2 A A 200 Row 3 C C 199 Row 4 A A 92 Row 5 C C 85 Row 6 D D 172 Row 7 D D 150 Row 8 E E 177 Row 9 E E 199...

5 replies Last reply on 9 Jan 2015 by
RayH

Copying unlimited data from on excel to another excel..

Hi All, I want to copy all the data from one excel sheet to another excel on load event (when I open) of destination excel. could you please hel...

5 replies Last reply on 9 Jan 2015 by
vcoolio

Setting due dates

I already have half of the formula needed.. d2=text, leave it blank =if(istext(D2),"","") I need a formula for this: d2=date, then add 14 day...

4 replies Last reply on 8 Jan 2015 by
jirinetmelissa

Looking at one cell if contains number returning text...

Hello, I am trying to figure out a way to streamline a huge excel spreadsheet we have at work. I am trying to return text in a cell if there is...

1 reply Last reply on 8 Jan 2015 by
ac3mark

Copy across conditional formats

Hello All ok I have 20 colomns of data the first 2 rows contain the upper and lower limits(all of which are different) the following 3 rows ...

1 reply Last reply on 8 Jan 2015 by
TrowaD

Compare two sheets based on a common id in both sheets in col a

 Solved

Greetings Kioskea team, First of all, my heartiest congratulations and thank you to the great Kioskea team that who have a mine of excellent solut...

8 replies Last reply on 8 Jan 2015 by
Ajay Dwivedi

Vlookup for mutiple shel

Hi , I have requirement as below There is excel sheet 1 with column A with some text say xxx, yyy , xyz and coresponding numeric values in colum...

4 replies Last reply on 8 Jan 2015 by
Karthikeyan1207

Vba to assign a counter to a constant

Can somebody provide me the VBA code for the following samples Before VBA code A B B A C A C A After VBA code 1A 1B 2B 2A 1C 3A 2C 4...

1 reply Last reply on 7 Jan 2015 by
RayH

How to convert dd/mm/yyyy to mm/dd/yyyy

Hi All, Kindly help to convert DD/MM/YYYY to MM/DD/YYYY for the following examples. Thanks in advance, 19/08/2014 13/08/2014 13/08/2014 4/08...

3 replies Last reply on 7 Jan 2015 by
Cathy

Copy and paste macro

hello, I am new to the vba programming for excel 2010 but what I have been able to ascertain has helped me tremendously at work, however I am having ...

1 reply Last reply on 7 Jan 2015 by
venkat1926

Converting numbers to alpha

I need a simple way to convert a price to an alpha code, for instance Graystoke = 1,2,3,4,5,6,7,8,9,0 so if a price is $5.66 it appears as s.tt I n...

1 reply Last reply on 6 Jan 2015 by
RayH

Percentage work

 Solved

Hi all, Good day!! Need help in Excel formulas. I'm creating a workbook to counting a value in multi percentage and multi level. Here I at...

6 replies Last reply on 6 Jan 2015 by
RayH

I need a macro please

Hello, I have 70,000 lines of data. I need to make 1400 files of 50 lines each from the original 70,000. So I'm hoping there is a macro that can p...

3 replies Last reply on 5 Jan 2015 by
RayH

Recurring weekly date

Hi, I'm wanting to set up a weekly review date for a number of rows on a spreadsheet. Each row has a different start date. I've tried WORKDAY.INTL wit...

5 replies Last reply on 5 Jan 2015 by
TrowaD

Text label and value if value in other worksheet is > 0

 Solved

Hello, can someone please help me with a formula for this. Text label and value, if value in other worksheet from 2 different cells is > 0, label...

5 replies Last reply on 5 Jan 2015 by
TrowaD

Question with if function

Hello, I was wondering, if I have for example in C2, C3, C4 the next info: "Tableta Onda V989 Allwinner A80 Octa Core 9.7 Inch Sistem Operare A...

1 reply Last reply on 4 Jan 2015 by
vcoolio

Take reference from previous sheet automatically

Hello, I make a payroll settlement sheet in excel every week. When i make next week sheet i copy previous sheet & start working on it. Sometimes i...

1 reply Last reply on 2 Jan 2015 by
vcoolio

Excel - to generate unique id

 Solved

Hello, Good day. I would like to generate a unique ID from date and a customer number field. I tried this way but it was not working as desired. Bel...

4 replies Last reply on 1 Jan 2015 by
ferg

Decrease the value first by 10% and then increase the value by 5

I want to decrease the value first by 10% and then increase the value by 5%. What is the formula in Ms excel.

2 replies Last reply on 1 Jan 2015 by
chandan

I need a macro please

 Solved

Hello, 1 spreadsheet has 15 columns of data with column A having the unique identifier 2 spreadsheet has 37 columns of data with column B havin...

7 replies Last reply on 31 Dec 2015 by
rjbuer

Excel using date range and formula on separate sheets

I'm creating a bank register with the dates in column A. Values are in columns C and D. The title of my first page is 'Register' What I'm trying ...

1 reply Last reply on 31 Dec 2015 by
vcoolio

Copy daily cost entries into the particular ledgers

 Solved

Hello, I want to copy the daily cost entires into the particular ledgers, which i put in different sheets. Ex: I have the following data: D...

6 replies Last reply on 31 Dec 2015 by
vcoolio

Need msexcel 2007 formula

Hello, Masters of Excel. I need formula like H5+I5+J5+K5+L5+M5+N5-O5=P5. I need H5 to N5 add & subrtact O5 in P5. Hope i have detailed this brief. T...

3 replies Last reply on 31 Dec 2015 by
vcoolio

Excel cell equal another cell only if its a certain percentage

Hello, I'm trying to have a cell equal another cell only if its a certain percentage (percentages are in another cell also, I tried "IFSUM" but its ...

6 replies Last reply on 30 Dec 2015 by
vcoolio

Date entry

 Solved

Hello, i have an Excel sheet which my colleague should enter the date after he finished his job, for example:\today date is 2014/28/12 he shou...

2 replies Last reply on 30 Dec 2015 by
ArashMan

How to lock or password protected specific cell in excel 2010

 Solved

Dear all: Hope you are fine. How can I Lock a specific cell of excel 2010 that any one can not change or input anything in that cell. Pleas...

4 replies Last reply on 30 Dec 2015 by
Biswajit-Shaha

Checking cell value against a range of numbers

Hello, I want to check a cell's value and if it falls in a particular range then I want to write "OK" in some other cell and if it falls out of sp...

1 reply Last reply on 29 Dec 2015 by
shanthich

Help with macro in excel

Hi I need some help in writing a macro for the below: 1. In sheet 1, I have column A with a list of items and many of them will be repetitive, ...

1 reply Last reply on 29 Dec 2015 by
venkat1926

Date change in excel sheet

Hello, in excel sheet date come to 29/12/2014 now i wants date on 29/12/14. so help me how to change date format or use formula to change date fr...

1 reply Last reply on 29 Dec 2015 by
venkat1926

Compare excel data

Hello, In excel i have say the following coordinate data: 2792691.388 215476.765 423.165 2792691.388 215526.765 423.045 2792691.388 215576.765 ...

1 reply Last reply on 29 Dec 2015 by
venkat1926

Excel macro to format report

 Solved

Hi everyone, I am new to this forum..........so new I've already typed my question, then clicked "ask your question" again instead of submit..........

7 replies Last reply on 29 Dec 2015 by
ramu sanga

Excel file is corrupt.

I hope one of the experts here will be able to save the files, which are very necessary for my work. My excel file became corrupt for very obvious rea...

2 replies Last reply on 27 Dec 2014 by
NikkiTum

How to format a cell based on date in another cell.

Hello, i.e. We want to format B1 based on date in A1. ( If date in B1 is 2 or more days higher from the date in A1, then B1 must get colored. This...

1 reply Last reply on 26 Dec 2014 by
Mazzaropi

Dropdowns in excel

There are multiple ways in which you can create a dropdown list in Excel. Data Validation Form Control (Combo Box) ActiveX Control (Combo Box) But...

1 reply Last reply on 23 Dec 2014 by
TrowaD
Results 2751 - 2800 out of a total of 7,061