## The discussions

### How to recover soft deleted emails ?

The exchange email inbox, which is available for me alows a max of 920 MB message storage space. When the mailbox reaches 720 MB, an automatic pop up ...

2 replies Last reply on 3 Sep 2014 by
datta_vg007

### Time calculation

Solved

Hello, dear all please I need a help for formula to calculate the duration ( hours ) between two dates for example : A1 ---> 1-8-2014 1...

2 replies Last reply on 3 Sep 2014 by
Osama_bb11

### Conversion of multiple column into single column

Hello, I have a date set in the following format 1 3 5 7 2 4 6 8 I want this in the format 1 2 3 4 5 6 7 8 Please help m...

aamirsq

### 4 conditional formats

I am attempting to add 4 conditional formats; First in red the 'cancel' - already done Secondly all things that complete on today's date in blue - d...

aamirsq

### Duplicating macro

Hi I currently have the below macro to duplicate rows for me but I want it to show the data in 2 columns instead of nderneath each other. EG OV...

7 replies Last reply on 1 Sep 2014 by

### How to convert number into text in excel

Hello, Thanks for the nice solution. I have a problem and that's what should I do if the number is bigger than 999,999,999? Configuration: Wi...

Kulmalik

### Formula that i can get a total for d7, if d7= d4 + (c6*d7)

Solved

\$1,613.00 (Cell D4) (C6) Hours ___ \$175.00 (D6) TOTAL (D7) Can any one tell me a formula that i can get a total for D7, if D7= D4 + (C...

2 replies Last reply on 29 Aug 2014 by

### Simple if function

Hello, I have a column reading random dates (dd/mm/yy) and the column next to it has to read "Y" or "N" depending on whether the date is before or...

2 replies Last reply on 28 Aug 2014 by
rayh

### How to copy data in cell ranges to another worksheet "if"

I have a source worksheet that is named "AVDistribution" and has several columns and rows of data and I have additional worksheets in the same workboo...

4 replies Last reply on 28 Aug 2014 by
ac3mark

### Conditional formatting between

Hi Ppl have conditional formatted a range of cells with numbers, to turn green if numbers are BETWEEN numbers in Column A and Column B but Proble...

venkat1926

### Need power point for dummies

Greetings from old school new freshman with power point presentation due in 2 weeks....yikes. what's power point? Thank You!!! I will let you know ...

3 replies Last reply on 27 Aug 2014 by

### Makin a powerpoint

Hello, how to make a best PowerPoint video Configuration: Windows 8 / Chrome 34.0.1847.116

3 replies Last reply on 27 Aug 2014 by
denissenco

### Microsoft office

how to use power point?

2 replies Last reply on 27 Aug 2014 by
denissenco

### Auto copying in excel

Suppose I have account in say 5 different banks and I have made one excel sheet for each showing date wise transactions. The sheet contains the follow...

venkat1926

### Comparing unsorted data across separate files

I need an automated way to compare the 2 sheets to make sure no equipment gets missed for ordering. I have to compare an order for equipment against ...

Mazzaropi

### Calculating a distance within an interval in a cell with text

I have a cell that contains words and numbers in the following format: Dig (30'-40', 50'-65'), Fill (70'-90') What I'd like to figure out is a f...

3 replies Last reply on 22 Aug 2014 by
Mazzaropi

### If -then formula needed please... before i head to the roof

Solved

Using Excel 2007, I need a formula to do the following: if the date shown in a cell is 1/31/14, display 'monthly activity - january, or if the date...

4 replies Last reply on 22 Aug 2014 by
hotpeppermom

### Extraction of excel data by using an excel column parameter

Solved

Hi, I have a problem in extracting information from an Excel Sheet 1 (entire database), by using an Excel column parameter (Model No) in Sheet 2. S...

5 replies Last reply on 21 Aug 2014 by
strikewind

### Conditional formating

I am working on a spreadsheet that tracks vehicles preventive maintenance. I would like the Mileage Last PM was performed (A1) to turn red when th...

Mazzaropi

### Insert number into cell based on other cells containing x

I am setting up a spreadsheet tracker for the school. I want J2 to auto fill a price depending on whether C2-G2 have an X. BUT, depending on which c...

Mazzaropi

### How to convert numeric to word in excel

How to convert numeric to word in excel

ac3mark

### Create a formula such that each cell in a given column auto

Hello, Is there a way to create a formula such that each cell in a given column automatically calculates a specific percentage of the value in the...

ExPatBrit

### Excel golf skins sheet

Solved

I need a micro that will highlight the cell with the lowest unique value in each individual column. It would not highlight anything if there were m...

2 replies Last reply on 18 Aug 2014 by
agw2010

### Need to merge data logically

Hello, I want Macro for below example, SUBACC STMTPG OPBALDT OPBALTP CLBALDT CLBALTP 123abc 1 04-07-2014 04-07-2014 123abc 1 05-07-2014 05...

### Help to debug this sentence for me please ?

Hi, Is there any way I can debug the sentence highlighted in yellow ? Thanks!

### Copying formula from column to another

Good afternoon, I have one calculation sheet with: - lines/column A: containing the items descriptions, - Column B: quantities - Column C: Unit ...

### How to get free microsoft office?

Solved

How to get free microsoft office?

Ambucias

### Vb script to notify/popup

Solved

I was having a difficulty in notifying my co-worker to print all the sheets on a workbook. I a thinking if it's possible to have an pop-up message to ...

10 replies Last reply on 14 Aug 2014 by
Sammysen

### How can copy one excel content to a new excel file by click comm

Hi dears, i am new user in this site So i hope you will find my requst as well I want to copy the filtered data to my excel file (my excel (Sheet,...

### Excel - a macro to re-arrange cells

I need your help to solve the following problem. I have files containing data about key contacts of company. Company Name,Concerned Person,Designat...

venkat1926

### Help in lookin up a value

Hello, I need help in getting a formula in excel i have two sheets the fisrt sheet is the refrence sheet the second sheet is where i write my ...

Mazzaropi

### Lookuk a value in 2 columns and get value of third (help)

Solved

Hello, I have a question I need to lookup a value of col A1 of sheet 1 in col A of sheet 2 and if it matches it gets the corresponding value ...

2 replies Last reply on 12 Aug 2014 by
sharifa6869

### Remove duplicated data

Solved

Hi, How do I remove duplicated data from 3 different worksheets in excel ? Like I have a column of client names on each worksheets. I need to com...

5 replies Last reply on 11 Aug 2014 by
SherlynPeh

### How to use conditional format on another cell

I want to format a cell using 2 conditions from a another variable cell. Example The cell i want to format is A1 using D1. when D1 is between 0....

6 replies Last reply on 11 Aug 2014 by
bbdwells

### Comparing two worksheets with different column values

comparing two worksheets with different column values

### Automation of pie chart using the values in excel

Solved

Hi, Anybody knows how to convert values into pie chart using macros instead of the insert function? Thanks!

4 replies Last reply on 11 Aug 2014 by

### I can't get my husband's gmail acount onto outlook

my husband has a samsung notebook but we can not get it to download his emails to outlook. does anyone know how to do it and please explain to me

Ambucias

Solved

I forgot my internet password , how can i get it .

Ambucias

### Erosdrews

where will I find a 25 letter product key?

3 replies Last reply on 10 Aug 2014 by
Ambucias

### Automatic transfer of data

Hi. I would like to know if there is a possibility of an automatic data transfer when using specific phrase. For example, this is what we put to each ...

gamer0912

### Ms publisher product key

Hello, Where do I find the Ms Publisher 2010 Product key? I just downloaded Ms Pub from the net. Thanks :)

xpcman

### Microsoft excel large file

Hello, Im working on huge file of excel. I have many different collums and rows. What i need: I need to copy all data from on generated excel fi...

Mazzaropi

### "countif" function for day of the week formatting

Hello there, Please help! I have a column of dates, where the formatting I've set for "Day of the week, month, day, year". How would I run a C...

2 replies Last reply on 8 Aug 2014 by
Jason

### Automatically move a row to another sheet

Hello, I have a sheet named SENT SMS with information about clients, the service they got, price, if paid or not. In the column P named PAID , if it...

### Excel macro

Hi, I'm doing a project which requires excel macros but I'm not familiar with it. There are 2 worksheets 'AMBS Master' and 'fy2013'. The data betwe...

### Transferring selected data from multiple worksheets to one

Solved

My team uses an excel to track our projects. We have many tabs (8) , but on each tab on Column A, we have a drop down menu that we can select if it's ...

10 replies Last reply on 5 Aug 2014 by
cpogata

### Automatically insert multiple pictures in excel under 1 ref

Dear all, I hope to find some help here as I would really like to find an easier way than just insert each picture manually. I am not a pro in VBA...

### More than one rule in excle

From the image posted I want to be able to highlight the row when the done column is empty and is not today's date.

Osama_bb11

### Locking a range based on a value of a cell

Solved

Hello, first I would like to thank every one working at kioskea my issue is , I want to lock a set of cells ( A2:M2) if the cell M2="app" and ...

4 replies Last reply on 4 Aug 2014 by
Osama_bb11

### Removing duplicate data

A call for urgent help to anyone out there. In capturing data from archived files I saved this both on my laptop as well as on a plugged in memory ...

9 replies Last reply on 4 Aug 2014 by
Mazzaropi
Results 3701 - 3750 out of a total of 12,259