The discussions

Removing " false" value in "if"

 Solved

Hello, I would like to know how to remove the "False" Value when if function is nested. Here is an Example =IF(C11="Evening",200,IF(C11="Gaze...

10 replies Last reply on 19 Jun 2017 by
share

Formula

 Solved

I am trying to find a formula that will add up all blank fields in a range of cells. For example, if cell 1,2,3 have data and 4,5 are blank I want the...

7 replies Last reply on 15 Jun 2017 by
x

Convert date of birth in word

 Solved

Hello, pls tell me formula for convert date of birth in word in excel

1 reply Last reply on 10 Jun 2017 by
Ambucias

Comparing values of two excel sheets

 Solved

Hello, I have two excel sheets with IP Codes. I need to find which IP Codes are not available in Sheet#1 and highlight them, i.e. Sheet#1 Column ...

2 replies Last reply on 10 Jun 2017 by
dh

Copy/paste a range 'n' times.

 Solved

Hello, I have a highlighted portion and I want to copy and paste it 200 times. Is there a code or formula to do this automatically? Or must I hit ...

3 replies Last reply on 9 Jun 2017 by
vcoolio

Conditional format

 Solved

Hello, I can not seem to figure out this conundrum. I am looking for conditional formatting to occur if cell $AI2 has

3 replies Last reply on 6 Jun 2017 by
Azion

Vlook up

 Solved

Hello, I have 2 columns A & B in sheet1 and i want to Return Yes if either A or B value mactches with Coulmn A in Sheet 2. Please help

2 replies Last reply on 6 Jun 2017 by
Sri

Spreadsheets viewing formulas

 Solved

How do I view hidden formulas on spreadsheet

3 replies Last reply on 29 May 2017 by
TrowaD

Vba send email via outlook using loop; no response when run

 Solved

Hello, the above code is not functional as described. Is there a way to check what is wrong? the screen does not show anything upon clicking the r...

9 replies Last reply on 29 May 2017 by
TrowaD

Vba code in my command button doesn't work

 Solved

Hello, I have a sample table below, I was trying different VBA code in my command button but doesn't work well. Column G is already programmed t...

1 reply Last reply on 28 May 2017 by
vcoolio

Vba column

 Solved/Closed

Need to know how to added data in column field if column is not empty then go to another column and paste data

2 replies Last reply on 28 May 2017 by
Ambucias

Format font colour to change

 Solved

Hello, Using Excel, I have a range of cells K2-K15 that contain numeric values and I want the font color to change in any of those cells that are g...

2 replies Last reply on 26 May 2017 by
jandc111

Copy rows to new sheets if condition is met

 Solved

Hello , please help... I'm trying to copy rows from master table sheet to different sheets based on the value of the cell in the column: The colum...

7 replies Last reply on 24 May 2017 by
vcoolio

How to "teach" excel to learn names?

 Solved

Greetings to all, I'm desperate to find a solution to my tedious work. So, each day i will go through hundreds of records and change product names...

2 replies Last reply on 23 May 2017 by
HoomanCz

Search for a value in column and copy to different sheet

 Solved

Hi I want to search for an employee ID in column EID and copy the whole record into another worksheet within the same workbook if the EID is found...

3 replies Last reply on 23 May 2017 by
raghuprabhu

If then using multiple cells and words

 Solved

Hello, D3,D4,D5 that all need to say either 'Compliant' or 'N/A', for result in E3 to say "yes", else "No". Please help. System Configurati...

4 replies Last reply on 22 May 2017 by
Matt Louisiana

Need help with conditional formatting

 Solved

Good morning, I am trying to change the color of a cell(A) if another cell (D) contains text. The text will contain both a date and other text. Can...

8 replies Last reply on 22 May 2017 by
x

How to copy data from sheet1 to sheet2

 Solved

Hello, I have a worksheet, there are 2 sheets. What I need is to do is copy all the column and rows from sheet1 and paste it to sheet2. The copy butt...

10 replies Last reply on 19 May 2017 by
nisa

Excel formula for percentage

 Solved/Closed

Hello, I am trying to get a formula to calculate the percentage of cell O3 from cell N2. The format is what percentage is my expense (O3) from my ...

4 replies Last reply on 16 May 2017 by
tanu

A macro to create new, copy and name worksheets based on a list

 Solved

Greetings, I need a macro that can automatically create new, copy (existing worksheet say '100') and rename the new worksheets, based on a list that ...

35 replies Last reply on 11 May 2017 by
vcoolio

Need help creating an if then scenario

 Solved

Hello, I am looking for some help with a problem. I have a big list of items within Excel and I am wanting to consolidate the big list of items do...

12 replies Last reply on 10 May 2017 by
vcoolio

A macro to copy/paste a cell and other cells in the same row

 Solved

I have two wooksheets in a workbook. I need that a value of each cell in a range C3:C52 in sheet 2002 is being searched for in the range B2:B101 of th...

3 replies Last reply on 9 May 2017 by
TrowaD

Trying to simplify data in excel through vbscript

 Solved

Please help desperate novice: In Excel, I have 5 columns: Bob Dad 12 13 blank Sue Mum 34 56 22 Gill Daughter 23 67 34 Jock Son 24 55 blank ...

3 replies Last reply on 8 May 2017 by
TrowaD

How do i use conditional formatting in excel

 Solved

Hello, i am new on this excel things but, i need it for work.. so, here it goes. is it possible if it like this ? example : A B C if A conta...

3 replies Last reply on 6 May 2017 by
Mazzaropi

Excel vba - find and expand matching cell entries

 Solved

Hello I have a list of 10 digit numbers in each row of a column range. Some of the numbers start with 3 zeros (000) which results in Excel ignoring...

1 reply Last reply on 2 May 2017 by
x

How to populate information on multiple sheets at once

 Solved

Hi all, I hope someone can help me figure this out. I have been imputing information on multiple sheets in an excel workbook for quite a while now ...

14 replies Last reply on 2 May 2017 by
TrowaD

Outlook 2007 is not sending mails

 Solved/Closed

Hello, Have a nice day. I migrate my data from one PC to another. The old one was having Windows XP operating system along with Outlook 2003 w...

32 replies Last reply on 2 May 2017 by
danigirl

Shortcut to edit a cell without using f2 key

 Solved

Hello, I'm working in excel (excel 2010) and using a Logitech Bluetooth keyboard. Normally to edit a cell, I would select the cell and hit F2, bu...

7 replies Last reply on 25 Apr 2017 by
BenFromSingapore

Data in a hot key

 Solved

Hello, I want to put an email address in a hot key so I don't need to type it ever time I need to insert it. Thanks for your help in advance.

4 replies Last reply on 25 Apr 2017 by
TrowaD

Conditional format if hyperlink

 Solved

Hello, In my workbook I have conditional format background color is green if there are a certain value in the cell. The text in the cell has font co...

12 replies Last reply on 24 Apr 2017 by
ac3mark

Compare the words in 2 columns in excel

 Solved

I gt two different excel file . So now my task is to compare the words in the entire columns in excel file 1 and excel file 2 , then output a new colu...

11 replies Last reply on 24 Apr 2017 by
TrowaD

Excel forum within a range

 Solved

Good day I am looking for a formula PLEASE. Example Column A, Column B, Column C, Column D, Column E, Column F No, Start, End, ...

2 replies Last reply on 24 Apr 2017 by
Gerberreinette

Convert wordpad document back to pdf

 Solved

Hello, i as sent a file and wheni went to open it it said open with word or internet i picked word and now its not what i wanted to have done beca...

10 replies Last reply on 21 Apr 2017 by
ac3mark

Need to delete columns based on column header

 Solved

Hello, I need to have an macro which will delete the columns from my excel based on the Column header. Exsample: I have the columns, Name...

7 replies Last reply on 21 Apr 2017 by
topazfae

Auto generation of code

 Solved/Closed

Hello, we facing issue in the auto generatation of vcode. it asking CUSTOMIZE HERE TO SUIT YOUR NEEDS . what code to be fill for this? kar...

1 reply Last reply on 20 Apr 2017 by
TrowaD

Excel - a macro to create new workbook and copy data

 Solved/Closed

In the example below, I want to copy Column A starting from row 2 ie: "Age" till the value available ie: "Code and column B starting from row 2 ie: "2...

29 replies Last reply on 18 Apr 2017 by
TrowaD

Excel - macro to create multiple sheets

 Solved

Hello, I have 16 sheets in excel. each of those represent a location (office) and they need to pull information from sheet1. This is for credit ...

5 replies Last reply on 14 Apr 2017 by
vcoolio

Comparing columns and returning value

 Solved/Closed

Hello, I have an Excel spreadsheet where I want to compare values between two columns and return the value from another column. EX: Column: A...

35 replies Last reply on 14 Apr 2017 by
kittu

Import .pdf ...?

 Solved

Hello everybody, Thanks so much for this thread, it has been extremely helpful! I have used the basic code suggested by Trowa, and it works for...

2 replies Last reply on 12 Apr 2017 by
RickRoll

Formula

 Solved

I need some help with a formula, everything I try just doesn't work. I usually don't have this problem with Excel today is my day. I have a colum...

2 replies Last reply on 6 Apr 2017 by
ehmetcalf

Conditional formatting based on two cell values

 Solved

Hi There, I'm using Excel 2016 and am trying to apply a conditional format that searches cells in column A for the text "*DEMO*", and also has a c...

3 replies Last reply on 3 Apr 2017 by
Mazzaropi

Copying cond. format for entire row based on 1 cell to other row

 Solved

I have conditional formatting for an entire row based on the value of 1 cell. For example: cell value>$A$2 = red, cell value

3 replies Last reply on 3 Apr 2017 by
Mazzaropi

Drop down lists

 Solved

Hi All, i have a drop down list in excel and the data for the list in a sheet in the same workbook. If I copy the spreadsheet with the list to anot...

3 replies Last reply on 31 Mar 2017 by
Mazzaropi

Removing false value

 Solved

Hello, I would like to know how to remove the "False" Value when if function is nested. Here is an Example =IF(G23=0,P15/Sum(D11:F11,IF(G23>0...

5 replies Last reply on 30 Mar 2017 by
ac3mark

Copy rows to other sheets based on value in column

 Solved

All, I have an Excel file with three sheets: Sheet1 contains all my data. Sheet2 named "MACH" and Sheet3 named "FAB" I am looking for a way with a...

6 replies Last reply on 30 Mar 2017 by
vcoolio

Pdf file alwasy opening in word

 Solved

Hello, What to do to disable my attachment file in pdf to open in Word application?

5 replies Last reply on 28 Mar 2017 by
blkdolphin

Trying to create a multi-column formula.

 Solved

Hello, I need help making a formula. I will do my best to describe. The letters (A-I) refer to separate columns. A-B=C to be divided by D the res...

9 replies Last reply on 28 Mar 2017 by
TrowaD

Excel problem

 Solved

Hello, I want a formula in which, If I enter the number in cell, the name of that number should appear in adjacent cell. Ex: Emp No Name 1 ...

3 replies Last reply on 22 Mar 2017 by
Mazzaropi

Recover user id of irctc

 Solved

Hello, recover irctc user id , i forgot it , so help me Configuration: Windows / Chrome 53.0.2785.101

2 replies Last reply on 22 Mar 2017 by
rishabhj2019

Excel find word in series of cells and add

 Solved

Hello, My colleague wants to has a spreadsheet with many columns and rows. The spreadsheet setup is something like this: Cells under column A ha...

3 replies Last reply on 17 Mar 2017 by
matt
Results 401 - 450 out of a total of 2,603