The discussions
Removing " false " value in "if&quo
Hello, I would like to know how to remove the "False" Value when if function is nested. Here is an Example =IF(C13="",IF((K13>="06:00"+0)*(K13="...
Excel 2010 code that clears content of a cell on open
Hi I am looking for code that clears content of a cell based on a value when the workbook opens. I have several sheets in the workbook with varied...
Conditional formating of row based on other cells
Hello, I am trying to format cells A7-E7 based on the relationship between C6 and C5. Ideally they would be coloured on a scale between green and y...
Specific data from one worbook to another (excel 2010).
SolvedHello there, I have two workbooks, one is an accounting spread sheet (named Cash Book) and the other has an Invoice Template (sheet 1) and Invoice...
If then formula using a date
Hi, I'm trying to create a formula where if the date falls on or after 08/01/2012 the value returned is .0464 and if its before 08/01/2012 the value r...
Excel 2007 custom filter problem
Solved/ClosedHello, I have been using Excel 2003 to sort phone numbers easily, using the custom filter and 'begins with' for example on numbers starting with 123. ...
Multiple columns using countifs
I have a column such as a1 --- 'Vendor' ----> (Win/Loss) column N ...
Comparing excel columns - help asap please!
Hello, I need help, please! I have two worksheets (C & Q). Each worksheet contains four columns, each column has different information(A=Date, B=Mis...
Run vba automatically when criteria is met
I want to be able to run a macro automatically when criteria is met.. If any cell in column A is change to "re-let" run "rowformat" macro can an...
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 ...
Time calculation
SolvedHello, dear all please I need a help for formula to calculate the duration ( hours ) between two dates for example : A1 ---> 1-8-2014 1...
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...
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...
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...
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...
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...
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...
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...
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...
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 ...
Makin a powerpoint
Hello, how to make a best PowerPoint video Configuration: Windows 8 / Chrome 34.0.1847.116
Microsoft office
how to use power point?
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...
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 ...
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...
If -then formula needed please... before i head to the roof
SolvedUsing 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...
Extraction of excel data by using an excel column parameter
SolvedHi, 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...
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...
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...
How to convert numeric to word in excel
How to convert numeric to word in excel
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...
Excel golf skins sheet
SolvedI 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...
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 ...
Vb script to notify/popup
SolvedI 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 ...
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...
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 ...
Lookuk a value in 2 columns and get value of third (help)
SolvedHello, 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 ...
Remove duplicated data
SolvedHi, 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...
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....
Comparing two worksheets with different column values
comparing two worksheets with different column values
Automation of pie chart using the values in excel
SolvedHi, Anybody knows how to convert values into pie chart using macros instead of the insert function? Thanks!
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
Erosdrews
where will I find a 25 letter product key?
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 ...
