The discussions

Conditional formatting: column a based on text values in columnb

Hi, I am trying to figure out a way to use conditional formatting to highlight the cells in column A based on the specific text in column B. I ...

1 reply Last reply on 8 Jul 2014 by
BunoCS

Help comparig data in two different excel spreadsheets

Hi. Im a little overwhelmed. i have one spreadsheet that i keep that has my 125 contracts and task orders on it. example: row 1 contract number ro...

1 reply Last reply on 7 Jul 2014 by
TrowaD

Multiple processors for excel

I work with very large spreadsheets in Excel on a Mac and I often have to wait for Excel to execute things like sort and fill. I'm hoping too solve...

2 replies Last reply on 6 Jul 2014 by
greepaul

Auto generate invoice number save and clear

I'm new to this site. I'm using excel 2013, I want a macro to auto generate invoice number, at the same time when I save it should copy and clear th...

1 reply Last reply on 5 Jul 2014 by
xpcman

If... then

Greetings all, I hope I can explain this correctly as this is my first time asking questions on a public forum. All me to set the stage. A = ...

2 replies Last reply on 5 Jul 2014 by
Osama_bb11

Format fill colour based on another cell

 Solved

Hi I would like to format my excel page so that the rows alternate between two fill colors based on whether two cells are equal or not. Here is an ex...

2 replies Last reply on 2 Jul 2014 by
EndlessDread

Calculating text to result certain text result

hi, if I enter S into cells a1 & b1 & c1 I need cell D1 to result 'CO'. if either cells a1,b1 or c1 has NYS entered into either cell or all 3 cells I ...

3 replies Last reply on 2 Jul 2014 by
Mazzaropi

Transfer cell data from one workbook to another workbook

 Solved

I am using two workbooks to track account spending for quarterly reporting. Workbook 1: Day Expenses Workbook 2: Monthly Expenses WB1: I have fo...

4 replies Last reply on 2 Jul 2014 by
Osama_bb11

Question about my if statement

Hello, I have an excel file with portions of addresses and i want to take the city state and zip code and put it in a separate cell. For that i u...

1 reply Last reply on 1 Jul 2014 by
Mazzaropi

Date format change in excel

 Solved

Hi, I have an excel worksheet with a date column in the format m/d/yyyy h:mm:ss AM/PM. How can I change it to the format d/m/yyyy h:mm? I tried the '...

2 replies Last reply on 1 Jul 2014 by
booor

Applying conditional formatting to rows that vary

I need to have AA turn red when the date is out of window of AB and AC. I have dates in column AB and AC the dates are all different in each row. I...

1 reply Last reply on 28 Jun 2014 by
rizvisa1

Date formate

i have 2 date formate example 06/11/2004 07-01-2004 and i want 1 formate and i useing this function =text(CellAddress,"DD/MM/YY") and text(...

1 reply Last reply on 28 Jun 2014 by
venkat1926

Numerical value is range of cells has a text value

Hi guys, This is for a holiday rota. if any sell has a 'h' in it I would like to total up the h's in a cell at the end as a numerical value of how ...

1 reply Last reply on 27 Jun 2014 by
Mazzaropi

Sum range if 2 conditions met

Hi, I have arrange of numbers which I would like to sum in a certain cell, only if a column contains certain text and another column contains another ...

1 reply Last reply on 26 Jun 2014 by
Osama_bb11

How to freely download softwares?

Hello, Please help me in downloading IDM, Mavis typing and Adobe reader free of charge. Thank you!

1 reply Last reply on 25 Jun 2014 by
ac3mark

Classic menu for word 2010 or 2013?

 Solved

Can you clarify? Will "Classic Menu for Word" work for Word 2013 or just for 2010? I see both on your download page.

2 replies Last reply on 25 Jun 2014 by
ofannod

If function for date ranges

I need to know how to do an if function: If D2 is >= 9/1/2008 and E2 is

1 reply Last reply on 25 Jun 2014 by
venkat1926

Formula help to add columns that contain text

I want to add the total of Column A (going to be text) and Subtract Column D if there is an "x". How do I do that formula? Anyone able to help? Exa...

1 reply Last reply on 25 Jun 2014 by
venkat1926

Libreoffice calc

How do I turn off the spell check in LibreOffice Calc? Trying to type in Wittenberg, and it keeps changing it to Gutenberg . Went in to Tools, and O...

1 reply Last reply on 24 Jun 2014 by
ac3mark

Hi all can you help me with the formula i require below

Im looking for a formula that will look at a number in row b and if that number is 1 will add 1 day from the date in row c and put it in row e, and if...

1 reply Last reply on 24 Jun 2014 by
RayH

How can rename multiple files once

Dear sir, PLS tell Mehow can rename Multiple Word ,Excel Etc Files Once Regards Santosh

1 reply Last reply on 24 Jun 2014 by
ac3mark

Excel - creating reminder pop up based on criteria

Hello, may you please help me in creating a reminder to pop up for every 5 hours once for a cell range having text equal to "pending" I was able t...

3 replies Last reply on 24 Jun 2014 by
TrowaD

Downloading pdf conversion

I would like to know if it is possible to download and install pdf converter to my laptop. thank you.

1 reply Last reply on 24 Jun 2014 by
BunoCS

Help: return day of the week

 Solved

Hello, I have checklist sort of form that I am printing every month to let them sign for task everyday. from C3 - AG3 it is numbered 1-31 and un...

6 replies Last reply on 23 Jun 2014 by
TrowaD

Excel - repeat rows to a specific number of times

 Solved

Hello, Hi Does anybody know how I can repeat rows in a spreadsheet (or into another spreadsheet) by n number of times specified in the cell in...

6 replies Last reply on 23 Jun 2014 by
daphtan

How to copy sheets from one work book to other

Dear Team. My query is Iam having two workbook in d drive as 1.xlsx and 2.xlsx i want to copy two sheets from 1.xlsx and paste in 2.xlsx ...

1 reply Last reply on 23 Jun 2014 by
venkat1926

Macro to add down a column

Hello all, I need a macro that will sum numbers down a column until it gets as close to 8 as possible. ex: 1 .5 .5 4 3 .5 3 2 so a ...

1 reply Last reply on 23 Jun 2014 by
venkat1926

Nested formula with 'or' statement

Hi, I have formula IF(ISBLANK(A3)," ", C3-TODAY()), which works absolutely fine but and i want to include another argument on it so that if value in ...

2 replies Last reply on 22 Jun 2014 by
jutulu

Sumproduct gives me error

Hi, I am using the below formula, but it gives me error. Any ideas why is that? I really should work same as the countif formula but instead it giv...

3 replies Last reply on 22 Jun 2014 by
jutulu

Find text in one cell, add different in another cell

Please be aware, I don't have much hair on my head to begin with and really don't have much to pull out either.. I'm frustrated. I've tried every ...

1 reply Last reply on 22 Jun 2014 by
Mazzaropi

Moving columns based on text

Suppose data is like this: 3 3 OPG 4 5 2 5 3 MCG 0 4 3 0 4 ELG 4 2 4 7 5 CTG 4 2 1 I want a macro ...

2 replies Last reply on 20 Jun 2014 by
Blind156

How to do recursive searches in excel

Hi, I have two worksheets. I need to be able to traverse a column in the first sheet and for each cell, compare it to a cell in the second sheet. If ...

1 reply Last reply on 20 Jun 2014 by
venkat1926

Cell auto filled with dots

 Solved

Hello, I sow it once but not sure where and can't work out how to do it. Basically, if I write things in excel, I need it to be auto filled with do...

4 replies Last reply on 19 Jun 2014 by
jutulu

Automatically transfer data from one sheet to another

Hello, I have a workbook in sheet1 details of materials issued to dealer for job work Sheet1 Columns: Dealer name, Date, Challan No, Item, Qty, etc ...

1 reply Last reply on 19 Jun 2014 by
TrowaD

How to copy data from one excel table to other

I have two sets of excel tables. The master table has got several columns with heads defined. Similarly, the row heads have also been defined. Now...

1 reply Last reply on 19 Jun 2014 by
TrowaD

Error in date formate

find attachment of date format issue .......how resole the error please let me know

2 replies Last reply on 19 Jun 2014 by
vinayak1986

Getting it set up

I get the program open and I start the process to get email to this new laptop and it fails. HELP!!!

1 reply Last reply on 18 Jun 2014 by
xpcman

Vlookup problem?

I have 4 Column A,B,C,D A=date B=MarketValue C=Results D=Numbers when i use the vlookup formula in other sheet it not working =vlookup(A2,Shee...

1 reply Last reply on 17 Jun 2014 by
Mazzaropi

Deleting rows with no data (in a range)

Hello, I have a sheet that I have been working on..all working fine, however I have one last bit that I cant seem to get right. Worksheet - "Fr...

3 replies Last reply on 17 Jun 2014 by
rizvisa1

Total and avg. data from another worksheet based on day of week

I am doing tracking for my employer. I have a sheet (Sheet 1) that I input data for every day of that month(i.e. 1st-31st) in the adjacent column I li...

1 reply Last reply on 17 Jun 2014 by
TrowaD

Adobe acrobat free download

How can I get a free download?

1 reply Last reply on 17 Jun 2014 by
BunoCS

Insert date from one sheet to another sheet ?

Dear Sir I have Two Sheets one Name is FirmDate and Other Event i want i put one date in Event and 260 Dates FirmDate uper of Select date in i...

3 replies Last reply on 17 Jun 2014 by
TrowaD

Excel how to question

Hello, I did not intend to offend anyone when i originally posted this message, I am new to forums and was not aware of the policy. I do apologize. ...

3 replies Last reply on 17 Jun 2014 by
TrowaD

Macro to rearrange data

I would like to enter a data as shown in the sheet 1 pic below and want it to be stored as shown in sheet 2. Can someone share how to code using macr...

8 replies Last reply on 16 Jun 2014 by
TrowaD

Conditional formatting special

Hi, I'm trying to create a conditional formatting to highlight the column if the cell in row 4 ="S". I can do it one column at the time, like the ru...

3 replies Last reply on 16 Jun 2014 by
TrowaD

If formula

hi all Please help me with this. Any help will be appreciated. Thanks in advance. if date in column A which refers to a text in column B..(A1 date...

2 replies Last reply on 16 Jun 2014 by
akram786

Auto select print area and prints

can anybody explain the Macro for auto select print area and print with a Print button in any cell i've a sheet with receipt. and i want to print r...

2 replies Last reply on 15 Jun 2014 by
man.jangra

How to delete strings of words from a range of cells

 Solved

I have a list of website for which some start with www. and others start with http://. I have been trying to remove the "http://" from all the cells a...

2 replies Last reply on 14 Jun 2014 by
Arrissa

Need formula for automatic date update in same cell

 Solved

Hi all, I was wondering if anyone knew of a formula that would allow excel to change a date in a cell automatically once a certain date had passed?...

5 replies Last reply on 13 Jun 2014 by
Osama_bb11

If formula

What is the mistake in this formula ?? =IF((D10>(B10/2))&((F10)

1 reply Last reply on 13 Jun 2014 by
ac3mark
Results 3801 - 3850 out of a total of 12,264