The discussions
Outlook express 6.0 losing contacts/error msgs. opening and send
SolvedDuring the last six weeks or so, whenever I install "updates" for my computer (Windows XP), my Outlook Express loses all my contacts, as well as becom...
Repair excel files.
SolvedHello Experts, My problem is as follow: We're reinstall an Laptop With Windows 7, but the user does not back up a folder, This folder contained ...
How to remove image with vb?
SolvedHello, I have everything working but removing the image before saving. The code is not working and not even sure where to place it. (using excel...
Conditional formatting based on another cell; apply to rows
SolvedHello, I have two columns. Column A is for expiration dates, and Column B has a drop down menu indicating the status of an request (eg, pending, a...
Need help with date and if statement newbie
SolvedHello, I am trying to work out a formula if possible, to determine a date based on a date in another cell. So if the Date in Cell A is 3/1/2015,...
Convert date into english words in excel
SolvedHello i want to know how to convert date into words(english) in excel 2003 or 2007 for eg. 22.04.2010 - convert it into Twenty Two April 2010 or ...
How to replace * with / in all formulas in an excel sheet
Solvedhi 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...
Time calculation (timexnumber)
SolvedHello, 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...
Conditional formatting with range
SolvedHello, 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....
If/or formula
SolvedHelp 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 ...
How to repeat a row 4 times, while increasing sequence
SolvedHello 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 ...
Converting rows of data in notepad to columns
SolvedHello, Needing help please. From a pdf data base supplied, I have copied the contents over onto notepad. The data within this notepad contains firs...
Conditionally copy columns
SolvedHello, 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...
Change a range dynamically - vba script.
SolvedHi 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...
Exchange inbox repair tool
Solved/ClosedHello, 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...
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!
Increment a cell value - conditions applied
SolvedHello, 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 ...
Rating from parameter lookup
SolvedHi.. 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...
Nesting if() functions?
SolvedHey 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...
Why dbx files do not opened
SolvedAs 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...
I am looking for outlook express fix tool
SolvedHello 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...
1 time data entry
Solved/ClosedHello, 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...
Due date reminder in excel to new sheet?
SolvedHello, 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...
Regarding pivot
SolvedHi 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 ...
Find the first available (empty) cell on a worksheet.
SolvedAs 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...
Lookup problem.
SolvedI 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...
Copy paste data in same column for multiple time
Solved/ClosedHello, i need following manipulation.... Data Before Column "A" 123456 123456 123456 123456 123456 ( After )Column "A" (After copy p...
Replacing duplicates
Solved/ClosedMy 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 ...
Excel - macro to highlight rows with duplicate values in a cell
Solved/ClosedGeetings, Kindly help us in creating a macro that highlight rows based on duplicate values in a cell [this cell may contain Alphabets, Numbers or ...
If function with date in excel
SolvedHi, 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 ...
Corrupt word file - says to use text converter
SolvedHello, 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 ...
Macro for copying data from different sheets
Solved/ClosedHello, I am trying to copy data from different sheets to master sheet under the following criteria 1. Master sheet should be generated when ev...
Trying to sum a column that contains various text
SolvedI'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 ...
Excel query urgent please.
SolvedHello, 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 ...
Compare two sheets based on a common id in both sheets in col a
SolvedGreetings Kioskea team, First of all, my heartiest congratulations and thank you to the great Kioskea team that who have a mine of excellent solut...
Percentage work
SolvedHi 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...
Text label and value if value in other worksheet is > 0
SolvedHello, 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...
How do i get my old inbox back?
SolvedMy 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...
Excel - to generate unique id
SolvedHello, 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...
I need a macro please
SolvedHello, 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...
Copy daily cost entries into the particular ledgers
SolvedHello, 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...
Date entry
SolvedHello, 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...
How to lock or password protected specific cell in excel 2010
SolvedDear 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...
Excel macro to format report
SolvedHi everyone, I am new to this forum..........so new I've already typed my question, then clicked "ask your question" again instead of submit..........
Need to write a macro to copy a row of information if true
SolvedHi, 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...
Using a macro to copy & paste from one sheet to another.
SolvedHello, 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 ...
Excel formula numbers to dates
SolvedHi, 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/...
How to use releative refrences in conditional formating??
Solvedthe 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...
Conditional formatting based on another cell
SolvedHello, 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...
