The discussions
If then formula with date
I have a spreadsheet that is tracking when a task is completed in Column C and then generating the next due by date in the next row column A so you kn...
Where does word 2010 save temporary files?
Hello, A co-worker lost a day's work b/c Word crashed and the auto recovered document didn't reflect her work. What folder does Word save temporar...
Copy info macro
Hello, I need a macro that can copy specific information based on specific criteria, and to be pasted into new sheets. so for an example i need all ...
How to search particular number string
Hi, I want to search particular number string from all the number data. E.g. - 9822013351 9822012146 9822030078 9822046440 9850038947 ...
Adobe reader could not open because it is either not a supported
SolvedHI i HAVE WINDOWS 7 AND WINDOWS XP AT OFFICE while opening one PDF file I am getting this error messege. Adobe Reader could not open because it is e...
Calculating fuel surcharge
Hello, I have the amount which includes freight charge+fuel surcharge that is $14.36. It is said that fuel surcharge is 22%. what formula should w...
Assistance with date formula
Hello, I got a whole lot of data saved as dd/mm/yyyy - need them to be converted to read yyyy/mm/dd - any ideas?
If formula for a range almost works, except with blank cells
SolvedApologies if the title is too vague. I will if necessary rewrite it to comply with forum rules. I have posted this same question here: https://www....
Formula required numeric convert in words
Hello, please confrim how to convert numeric in words in excel. Simple formula required
Positions (1st, 2nd, 3rd etc)
No Name Eng Maths Bio Econs Distinction Credit Pass Fail 1. John Dan 56 67 78 66 ...
Excel macro to create dropdown value of the sheet and values
Hello, I have spreadsheet containing multiple sheets and values in it. I would like to make a macro tool to create a dropdown button of the sheet a...
Auto transferring data from one cell/row to another sheet
Hello, Good Morning. I have a list of transaction in one sheet. With a column showing the sheet name where the data of that row should be trans...
Change cell colour based on values in other columns.
Hello, I would like to change cells in column C base on numbers in Column A and B. So for example, A1=3, B1= 1, C1= Red A2=2, B2= 2, C2= yellow ...
Converting back to word perfect from pdf doc
Hello, all my documents "somehow" have converted themselves from Word Perfect to PDF. how do I change them all back to Word Perfect? thank you ...
Index , array and need help with print
Hello, I have a database and I created a form using this database . I used "index" syntax and it works but my problem is I need to print this form...
Offline address book help for exchange 2007.
SolvedInstalled new copy of Exchange 2007. Keep getting following message: Offline address book definition is missing. Need help with this issue. Thanks.
Cannot browse - ftp ok, email ok, ping ok
SolvedHello, I have been following the thread from people with similar problems but mine is not fixed. This all happened yesterday when AVG falsely ident...
Date format
SolvedHello, i have a column in format like 14-02-14 and i want to change it like14-02-2014
If condition formula required
SolvedHello, Thank for the earlier reply. Please help in correcting the formula given below. condition is if a column is AB2>=1 it should reduce no. ...
Outlook error
Hello, I have a error in outlook that ; Send test e-mail message: Your server does not support the connection encryption type you have specifie...
I need to make a macro with many difficult functions
Hello, I have a basic understanding of macros, but I have never written a macro, or developed something of this complexity. The user of this ma...
How to enable my blutooth on my lap top?
Hello, i have a dell lap top latitude E6400 and the blutooth is not working,is there any solution? thank you. Configuration: Windows 7 / Chrome...
If condition formula using dates/no. of days in the moth
ClosedHello, I work for a financial institution and looking for a formula with IF condition.If i collect that month installment, It should reduce the no ...
How to copy data from one sheet to multiple sheets using if
Hi, We have one sheet were the master data is entered. There are different users who input data on this master sheet. How can this data be copied o...
Excel consolidation tab
SolvedHi all, I am wondering if it is possible to exclude one spreadsheet from being pulled into the master tab. I could name it Data. Can you advice? ...
Customer protected form and posting my data into
I have a customer who sends me a Excel bid form that is protected and they want us to enter our price, manufacturer name, catalog number and delivery ...
Excel formula to add day in cell from date
Hello, Is it possible to have a formula that automatically adds the day to a cell if a date is entered into another cell. For example, Column A...
Unlocking of the locked file
Hello, i have a password folder but i do not need that folder to be protected anymore. what do i do to permanently deactivate such password? Co...
If cell a1 has text then cell b2 has today's date
SolvedHello, I'm trying to find a formula that writes, If Cell A1 has text or any value, then B2 should show today's date and time. Can someone help m...
Excel date format change
Hello, I have use MSoffice-2010,in a excel sheet there is some data with 72 rows.Main issue is when I sent the excel sheet to my friend he got the ...
Comparing two excel sheets
Hello, i have 2 excel sheets, each with 2 columns name and email. the scenario is i want to compare both sheets and display those which has the same...
Excel - repeat rows a specified number of times
Solved/ClosedHello, I'm aware of the post here https://ccm.net/apps-sites/software/1603-how-to-repeat-rows-a-specified-number-of-times-on-excel/ But I wo...
How to repeat rows by x number of times
SolvedHi 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 that row ...
Highlight jobs that are due.
Not even sure where to begin on this one and not sure it's possible either but thought it's worth a try. I have a document to record date's when jobs ...
Computer master's password
Hello, since i m new to these things, so can anyone explain to me what does computer master's password means? Configuration: Windows XP / Chrom...
How to repair large outlook 2007 pst on windows 7
Solved/ClosedHello, User running Windows 7, with Outlook 2007, 20 GB PST. User has two email account, 1 may be an IMAP, 1 may be POP, or both can be POP (I'l...
Excel 2003 question. on conditional formatting using vba
Hello, i have been trying to figure out how to make my code stop bugging out on me. any and all help will be greatly appreciated. Option Compare ...
Rounding function
SolvedHello, Good day!! For the Excel rounding function normally is 4 down 5 up is it possible that rounding the digit as below request? 115.21...
Conditional formatting
I have a document in excel where I want to change the colour of a number of cells based on information in one. So I'm guessing a formula will be neede...
Vba to refresh all pivot tables
SolvedHello, One of my worksheets has about 40 pivot tables. I know that there is a pivot table option to "refresh tables when opening file". But my raw ...
Macro to add/remove rows based on highest # in group of cells
SolvedI am looking for a macro that will look at a predefined group of cells (say A1-A5) and create as many rows based off the highest one on another sheet....
Insert row data on sheet2 based on sheet1 cell value(text)
Hello, i have two sheets i.e., sheet1,sheet2 in Sheet1 row fields like A B C D E in that D field value like RC based RC value insert whole RC ...
How to match 2 lists to get the unique entries
I have two spreadsheets, one containing a complete list of titles in a database and the other containing a subset of that list. I want to find the en...
Calculate formula based on values for two dates
Hello, I'd like some help with calculating a formula that uses values corresponding to specific dates. I have a list of daily dates and a value ...
Conditional formatting help
Hello, I have a spreadsheet which we use for tracking all outgoing shipments. I have the expected delivery date in one column, and the actual deli...
Combining rows
Hello, My situation is similar to a question that was asked but not exactly the same. This is how my spreadsheet looks now: A 1 1 0 0 1 1 A 0...
Conditional formatting based on range ofcells in different sheet
Hi, I'm trying to make the conditional formatting based on as follows: cell in sheet 2 is getting red if anywhere in sheets 1,2 and 3 could be f...
Replacing a value using lookup table
Hello, I am looking for help on writing a macro that will perform replacement that will replace the values from A1 to the end of the first row on Shee...
Copy specific cells to separate worksheets upon 2 conditions
SolvedHello everyone, vcoolio has kindly written me a script to copy and paste specific cells from Sheet1 to Sheet2 if ONE condition is met (ie "Yes" is...
Check if cells are blank or zero help please
I have a spreadsheet where columns A and B will either contain numbers or be blank. I need to add a formula into column C (for example cell C2 which ...
