The discussions

How to replace * with / in all formulas in an excel sheet

 Solved

hi Guys, does anyone of you know please how to replace the multiply sign with a divide sign in all of the formulas in an excel sheet? I could not f...

4 replies Last reply on 18 Feb 2015 by
DG83

Time calculation (timexnumber)

 Solved

Hello, i want calculate the salary of workers like the following example. worker No.1 salary/hour 1$ working hours this week 3:45 (3 hou...

4 replies Last reply on 17 Feb 2015 by
ArashMan

Even page numbers missing

 Solved

Can anyone help Header and page numbers missing on even pages!

2 replies Last reply on 16 Feb 2015 by
drumgora

Conditional formatting with range

 Solved

Hello, I have a little bit of a problem, I want to mark a cell in a range that is equal to another cell in different range, I can't figure it out....

2 replies Last reply on 10 Feb 2015 by
MindTwister

If/or formula

 Solved

Help please I need to look up a cell and if it =1 return 1, =2 return 0.6, =3 return 0.4, = 4 return 0.2, if >4 return 0.0 for example A B ...

3 replies Last reply on 10 Feb 2015 by
vcoolio

How to repeat a row 4 times, while increasing sequence

 Solved

Hello all, I need help on the best way to repeat this 4 times, and then increase the number at the end. I need this: Column A AAA_BBB_0002135 ...

2 replies Last reply on 6 Feb 2015 by
OldCoder

Converting rows of data in notepad to columns

 Solved

Hello, Needing help please. From a pdf data base supplied, I have copied the contents over onto notepad. The data within this notepad contains firs...

2 replies Last reply on 5 Feb 2015 by
Philgood_FR

Conditionally copy columns

 Solved

Hello, I have a table with thousands of rows of text. Column B has errors in the data which I have fixed in column C (has many blank cells). I would l...

2 replies Last reply on 4 Feb 2015 by
GMHerbs

Change a range dynamically - vba script.

 Solved

Hi everyone. I am stuck on a small problem with writing a Macro in Excel and would appreciate some help. I have the following script: For...

5 replies Last reply on 4 Feb 2015 by
BrianGreen

Exchange inbox repair tool

 Solved/Closed

Hello, I have Exchange 2010 server that is being used to temporarily hold mailboxes. After a reboot the .edb file went from 276gb to 0kb. Of cour...

2 replies Last reply on 3 Feb 2015 by
sorincornea

Removing false in excel

 Solved

=IF(D5>=150000,D5*21/100,IF(D5>=100000,D5*15/100,IF(D5>=70000,D5*21/100,IF(D5>=50000,D5*7/1000)))) What,s wrong in this formula Please Help!

2 replies Last reply on 2 Feb 2015 by
umer007

Increment a cell value - conditions applied

 Solved

Hello, I needed a formula to add a value to a cell when the cell next to it contains a value where that value is obtained by incrementing the value ...

2 replies Last reply on 1 Feb 2015 by
peweuk

Rating from parameter lookup

 Solved

Hi.. I have some data that reference parameter to fill Rating in my excel sheet. The problem is those parameter are in Text Type. Here is the e...

11 replies Last reply on 30 Jan 2015 by
dxa02091

Nesting if() functions?

 Solved

Hey guys, I'm relatively new to Excel, so bear with me here. I'm making this spreadsheet to check if the payments of certain products are either la...

3 replies Last reply on 29 Jan 2015 by
pijaku

Why dbx files do not opened

 Solved

As soon as I have not tried to open the file through Outlook. Out - walked into account. Downloaded the new version - nothing helped. Outlook does not...

1 reply Last reply on 27 Jan 2015 by
wauters87

I am looking for outlook express fix tool

 Solved

Hello everyone...How can i restore damaged .DBX file of OE? I am not able to see the mails. My 4 Gb data in inbox.dbx is corrupted of .dbx files by u...

2 replies Last reply on 24 Jan 2015 by
samlund

1 time data entry

 Solved/Closed

Hello, is there any way that make a condition for a cell which don't let to any body change the cell after they enter the date. i mean when i enter...

14 replies Last reply on 23 Jan 2015 by
ArashMan

Due date reminder in excel to new sheet?

 Solved

Hello, I Have a problem in this code =INDEX(Master!$B$3:Master!$B$1067,MATCH(TODAY()+30,Master!$H$3:Master!$H$1067,0)) HERE I HAVE COLUM...

5 replies Last reply on 22 Jan 2015 by
Babu546

Regarding pivot

 Solved

Hi I am doing Pivot for multplie data . In the Value field ( bottom right ) , I need SUM as default instead of count . I have to drag multiple ...

2 replies Last reply on 22 Jan 2015 by
Karthikeyan1207

Find the first available (empty) cell on a worksheet.

 Solved

As a newbee to VBA, my boss has given me an impossible task ... Basically I need to be able to enter one cell worth of data from one sheet of a wor...

19 replies Last reply on 21 Jan 2015 by
BrianGreen

Lookup problem.

 Solved

I have a column of 20 dates in col. B spaced by 2 or 3 weeks, and a number beside each one in col. C. In cell C24 I need a formula that returns the v...

5 replies Last reply on 21 Jan 2015 by
Babu546

Copy paste data in same column for multiple time

 Solved/Closed

Hello, i need following manipulation.... Data Before Column "A" 123456 123456 123456 123456 123456 ( After )Column "A" (After copy p...

5 replies Last reply on 21 Jan 2015 by
sree

Replacing duplicates

 Solved/Closed

My Excel spreadsheet is set out as follows: A B C D E F 1 2 14 0 14 14 2 1 13 0 13 13 3 4 4 1 4 4 4 3 3 1 3 17 ...

38 replies Last reply on 20 Jan 2015 by
TrowaD

Excel - macro to highlight rows with duplicate values in a cell

 Solved/Closed

Geetings, Kindly help us in creating a macro that highlight rows based on duplicate values in a cell [this cell may contain Alphabets, Numbers or ...

11 replies Last reply on 19 Jan 2015 by
TrowaD

If function with date in excel

 Solved

Hi, hope someone can assit. I need to create a sheet where I must take the current date and add a fulle week or two weeks to the date by selecting an ...

2 replies Last reply on 19 Jan 2015 by
ace-82

Corrupt word file - says to use text converter

 Solved

Hello, I have been reading some posts about you to repair a file and it says to use the text converter. I dont see how to use it though. I want to ...

1 reply Last reply on 16 Jan 2015 by
josephcols81

Macro for copying data from different sheets

 Solved/Closed

Hello, I am trying to copy data from different sheets to master sheet under the following criteria 1. Master sheet should be generated when ev...

23 replies Last reply on 16 Jan 2015 by
NK

Trying to sum a column that contains various text

 Solved

I'm a novice when it comes to excel and I'm hoping someone can help me with a formula. I'm trying to give a value to various text in columns and then ...

3 replies Last reply on 15 Jan 2015 by
chris82675

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

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

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

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

How do i get my old inbox back?

 Solved

My computer had some network difficulty. After shutting down I noticed my Outlook Express inbox was empty. When browsing to my OE folder I see two i...

1 reply Last reply on 5 Jan 2015 by
wilkersonbria

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

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

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

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

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

Need to write a macro to copy a row of information if true

 Solved

Hi, I have a workbook with several tabs and I want to first check if Column F on the first sheet contains 13 as the year (12/16/13 is the format) and...

7 replies Last reply on 22 Dec 2014 by
vcoolio

Using a macro to copy & paste from one sheet to another.

 Solved

Hello, Hi Guy's I hope you can help, I am using two sheets. one is spread across different rows so when I click create list it copies everything ...

8 replies Last reply on 18 Dec 2014 by
vcoolio

Excel formula numbers to dates

 Solved

Hi, I need an excel formula for changing numbers to dates. It is part of the Julian Calendar but backwards and one extra number. Ex. 273143 is 9/...

6 replies Last reply on 18 Dec 2014 by
ah2jh1sh2

How to use releative refrences in conditional formating??

 Solved

the first picture is the formatting rule of C7 cell the second picture is the formatting rule of E7 cell which i copy from C7. as you c...

8 replies Last reply on 18 Dec 2014 by
Mazzaropi

Conditional formatting based on another cell

 Solved

Hello, this is what I want: EXAMPLE: B3= Arash if B6=1 then B3 goes red if B6=2 then B3 Goes yellow and if B6=3 then B3 goes green i want to...

2 replies Last reply on 17 Dec 2014 by
ArashMan

Conditional formatting based on another cell

 Solved

i want to type a name in cell B3. and I want the cell's color change when I type 1,2 or 3 in B6 cell by using conditional formatting. is that possible...

5 replies Last reply on 17 Dec 2014 by
ArashMan

Help me to add particular cells

 Solved

Hello, i want to sum particular cells when a number consists in a cell eg:- =IF($B$81:$BH$81=7=TRUE,SUM($B$77:$BH$77),0) it calculates a...

2 replies Last reply on 15 Dec 2014 by
mathew munna

Macro/command button help

 Solved

Hello, I am in need of some help here and would greatly appreciate it. Here is what I am trying to accomplish. I have a basic excel file with two s...

12 replies Last reply on 13 Dec 2014 by
vcoolio

Copy info from one excel sheet to another sheet

 Solved

Hello, I am respectfully asking for assistance on an issue i am having trying to write a macro for a form that i am currently working on. I have ...

2 replies Last reply on 12 Dec 2014 by
sstanger

What type does it want? (vba question)

 Solved

Hello, So I have a pull-down list in Excel 2003 that is an expanded version of this: 011 012 01T 111 If I type in the cell (rather than ...

3 replies Last reply on 11 Dec 2014 by
TrowaD

Conditional formatting to hide 00:00 in column

 Solved

Hello, I would be very grateful if there is somebody who could help me find the solution to what is most likely a simple problem. I don't have a grea...

4 replies Last reply on 8 Dec 2014 by
Sharky9000
Results 951 - 1000 out of a total of 2,603