The discussions
Converting date to year and month text
Solved/ClosedHello, I have a cell date entered as 8-Nov. Excel reads this date as 11/8/2010. The cell entry actually means Nov, 2008. I need to change that ...
Conditional formatting
Hello, If cell P5 is greater than Q5, I need cell R5 to equal Q5. If P5 is less than Q5, I need cell R5 to equal P5. Any help would be appreci...
Selection of data from multiple sheet
Hello, I am facing a problem, regarding selection of specific rows from multiple sheet in a single workbook. Details: I have a workbook with...
Using vlookup to return insted of 00/01/1900
SolvedHello, I am using a Vlookup to return values within a sheet using cell A2 as my reference some of the data that I am returning via the lookup are ...
Excel 2010 - macro for filling in top half of several excel form
Hello, I have about 14 Excel 2010 forms that lines 2-6 contain the identical information, after filing in the information in on the first form, I ...
Formula for between to dates
SolvedHello, Hi, I am looking for a date formula that will tell me if a date in a cell is between to dates In column "A" I have a list of dates and in c...
Conditional transfer of rows to another sheet
Hello, I am working on a production worksheet. Sheet1 is called "Lead Input" and contains columns of names, addresses, prices, etc. There are two ...
Stop #n/a appearing after a vlookup
Solved/ClosedHello, I need to stop #N/A appearing after doing vlookup. I Understand that this happens because it refers to no value. Anyway I can make it ap...
Balancing totals from two workbooks
Hello, I have tried some pivots, some access but still no solution. I have data coming from two different sources. One has a breakdown for some...
Hide the formula
Hello, I am creating an excel sheet where I need to have a cell show 55% of a number that will change weekly. How do I set it up where the original...
Conditional formatting
Hello, I'm using Excel 2010 (not sure whether or not that matters) I'm not very familiar with conditional formatting, so I need help with somethi...
Looking for a value in a cell
Hello, I am using the following formula below =IF(OR(A1=" ",B1=" ",C1=" ",D1=" ")" ",G1) What I am trying to do is if all the cells are blank ...
One cell will turn green when the two other cells match
SolvedHello, I am keeping a register of staff in our department. What I want to happen is for the cell (where the name is) to turn green when the date ...
=month(d2)
SolvedHello, Empty cell in Excel file has changed in the month, while 0 is 1 reply should have come to help please Configuration: Windows XP / Chrome...
Adding specific days to date
Hello, Configuration: Windows 7 / Internet Explorer 9.0 how to add 21 days to date 25.02.2012 in Cell A1 in excel 2007
Excel formula not working - why?
Hello, I have trouble with this formula and I'm new to Excel, can you tell me why isn't working? =IF(ISNUMBER(SEARCH("1.1",A17:F17)), F17, "") ...
Macro to email picking up email address in one cell using lookup
SolvedHi can anyone help me I am using the VBA below to email a results sheet to various people,the code that I have will only allow me to email to one pers...
Duplicate data from on tab to a master tab
Hello, I need to create a work book wit 5 tabs? The 1st tab will be a Master Page and the 2nd,3rd and 4th will be data inputted by other users,...
Returning value from column b in column c, in a cell ajacent to
SolvedHello, BHID MN Samp 47.86 Samp 50.24 Samp 41.63 Samp 49.34 Samp 48.19 Samp 53.11 Samp 50.98 Samp 49.07 Samp 48.05 Samp 52.96 Samp 41...
How to download?
Hello, I want to down load Excel and Microsoft Publisher Configuration: Windows 7 / Internet Explorer 9.0
Recovery my work and restart microsoft excel
Solved/ClosedHello, everyone i have a problem with my excel while I start this program then open the file in MS Excel. Excel pops a message saying "MS Office ...
Compare data in seperate columns to find likely matches
SolvedHello, I want to compare data in columns which essentially is the same but worded different. For Example Name of Person County...
No tool bars or address bar on my browser
Solved/ClosedHello, I don't know what I did, but my address bar is only visable when I drag my mouse up to the top of my screen and my toolbars have disappea...
Excel function
Hello, please i need your help in the following problem I have one worksheet contains many colums, rows, and calculations as follows: empl...
Code for macro that conditionally inserts rows
SolvedHello, I know this has been asked and answered often, in particular here: https://ccm.net/forum/affich-222200-insert-rows-on-change-of-value-in-excel-...
Help!!! conditional formating
Hello, I have a spreadsheet (d2:d7) with 2012 prices in column D2 and 2013 prices in column D3 for the same product...what i want is if D2 is bigg...
Excel if function: less than date
Hello, I need a what if formula to satisfy the following: if date in K34 is before 23 Nov 2012, then AB34 = yes and so on.. i.e date in K35> 23 N...
Excel for mac opens all files on desktop
Solved/ClosedHello, Whenever I open any Excel file, Excel opens every file on my desktop as well (excel or not). I have to wait until the whole bunch load up, t...
Is there anyway to use vlook with index
Hello, I have hard time to solve this: I have problem like this: 1st worksheet I have a table similar than this: A B C D 1 D...
Microsoft word free download
Hello, i am wondering how i can download microsoft word free onto my computer help please... Configuration: Windows 7 / Chrome 24.0.1312.57
Can't open excel file
Solved/ClosedHello, I'm running a Mac (10.5.8) and am having trouble opening a recently created Excel file. I was able to open the file since the first time I ...
Office
Hello, I have just downloaded project 2007 from this site but I need a product code to activate it. Can anybody help me with this? Your assistan...
If statement errors and using multiple if statements.
SolvedHello, I am self teaching excel spreadsheets, and I would really appreciate some help to anyone that would graciously be willing to offer it. I ...
Comparing two xl sheets
Hello, I have two excel sheets. A and B A has two columns col1 ,col2 B has two columns col1 and col3 i want create new sheet which has col1 ,...
Conditional formatting of cell in other worksheet dependent
ClosedHello, Hope I make this one clear. I am working on a workbook created by a another and here is what I am trying to achieve. An item selecte...
Can this be done? if yes, how?
Hello, This is my beginners attempt to write VBA code (I just wrote a macro to write MsgBox "Hello World" :-)) Please chk the Following ex...
Writing rule in ms excel using vb
Hello, my question is...i'm having huge customer list mails in the format ******@***.es.us ******@***.es.in ******@***.net.us ******@...
How to expert office excel work
Hello, I'm Salman i live in dhaka. i work in a company. some time facing many problem to office excel work. Pls told me to how to improve excel wo...
Conditionnal formating for more than 3 colors
Hi, I need some help with conditionnal formating. I have 27 conditions and for each I need a separate color. 1,0-2,0 2,0-4,0 4,0-6,0 6,0-...
Merging more cells into one cell
SolvedHello, how to merge 3 cells into 1 cell? we tried and tried but we didn't get it.. even the formula, we don't know.. we are just a first timer. w...
How can calculate days between twodates
SolvedHello, I HVE TO CALCULATE THE DIFFRENCE IN DATE. e.g: there is a two coloums as per below, purchase requisition date purchase order date ...
I want to insert an image without a background
Hello, How can i insert an image without a background using .. ACDsee Pro 5 ... and if i could do it with another programe what is it and what is ...
How to insert & resize picture automatically
Hello, Configuration: Windows 7 / Chrome 24.0.1312.57 Sir I have an Excel 2007 file named "DTPH.xlsx" with data having person names, details i...
Insert row with formats and formulas
Hello, I am curretly trying to write a macro, that will insert a row on the next available line, keeping the formulas, formats, (including some co...
Recurring billing fee
Hello all, I was wondering if anyone knows a way to have Excel add a monthly billing charge to invoices. I need something that would automatically...
Organisation chart preparation
Hello, how to prepare organisation chart Configuration: Windows XP / Firefox 18.0
Macro to count the answers in a table
Hello, I have a problem in macro in Excel. I am working on a file that counts the number of responses (0 or 1) of a certain type under certain que...
How can i recover my exchange edb mailbox into pst?
ClosedHello, I need to recover my Exchange EDB mailboxes into PST from corrupt Exchange environment. Can you please tell me how can i recover my Exchange...
Macro to download certain files from a webpage
Hello, I am trying to find a way to download a number of files that exist on a webpage (the names are in sequence, e.g. abc202, abc203, abc204...e...
Changing cell formats based on another cell value
Hello, I was having difficulty in solving this problem. say: I have a dropdown on A2, text1, text2, text3 when you selected text1 the format...
