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...

1 reply Last reply on 2 Sep 2014 by
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...

1 reply Last reply on 2 Sep 2014 by
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
TrowaD

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...

1 reply Last reply on 31 Aug 2014 by
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
dmadden

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...

1 reply Last reply on 27 Aug 2014 by
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
johnebadbak74

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...

1 reply Last reply on 25 Aug 2014 by
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 ...

1 reply Last reply on 23 Aug 2014 by
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...

1 reply Last reply on 21 Aug 2014 by
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...

1 reply Last reply on 21 Aug 2014 by
Mazzaropi

How to convert numeric to word in excel

How to convert numeric to word in excel

1 reply Last reply on 20 Aug 2014 by
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...

1 reply Last reply on 19 Aug 2014 by
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...

1 reply Last reply on 18 Aug 2014 by
TrowaD

Help to debug this sentence for me please ?

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

1 reply Last reply on 18 Aug 2014 by
TrowaD

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 ...

1 reply Last reply on 18 Aug 2014 by
TrowaD

How to get free microsoft office?

 Solved

How to get free microsoft office?

1 reply Last reply on 18 Aug 2014 by
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,...

1 reply Last reply on 14 Aug 2014 by
TrowaD

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...

1 reply Last reply on 14 Aug 2014 by
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 ...

1 reply Last reply on 13 Aug 2014 by
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

1 reply Last reply on 11 Aug 2014 by
TrowaD

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
TrowaD

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

1 reply Last reply on 10 Aug 2014 by
Ambucias

Forgot my internet password

 Solved

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

1 reply Last reply on 10 Aug 2014 by
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 ...

1 reply Last reply on 10 Aug 2014 by
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 :)

1 reply Last reply on 9 Aug 2014 by
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...

1 reply Last reply on 9 Aug 2014 by
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...

1 reply Last reply on 7 Aug 2014 by
TrowaD

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...

1 reply Last reply on 7 Aug 2014 by
TrowaD

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...

1 reply Last reply on 5 Aug 2014 by
TrowaD

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.

1 reply Last reply on 4 Aug 2014 by
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