The discussions
Excel formatting
Hello, I am having trouble with a formula in Excel. I have 600 rows of financial data. Column A has numbers 1 thru 6, which correspond with differe...
Need help with percentage please
SolvedHello, I am new to excel and I am not very good at it so any help would be greatly appreciated. I know anyone out there is helping for no reason o...
How to get the data while entering in the other cell
Hello, Thanks for your reply. But what i need is if i enter a student ID in a cell in sheet 1 it must open the student details of concerned id in...
High and lower case text in the "if" functions
SolvedHello, I am working on a basketball spreadsheet. I am keep track of the home teams straight up(SU) wins. Home teams are capitalized(higher case), ...
How to find the data by entering the data in one cell
Hello, we are dealing with projects of different colleges. there is a data of more than 1000 students. each time i have to click on the respective...
Copy rows to different spreadsheets based on 1 column
Hello, I have a spreadsheet where I track open orders for my company. We track this by multiple metrics and values. I currently manually copy and ...
Populate data in excel according with n
SolvedHello all, My intention is populate an Excel sheet with a variable number of rows according with a number inserted on a fixed column. co...
Can't send or receive email in outlook 2007
Hello, For some reason Outlook stopped sending and receiving messages. I have no connection problems but receive a message saying 'receiving repo...
Conditional formatting using dates in different cells
SolvedHello, I need help with a problem that is driving me insane. I have column A, B, and C A is date started B is date finished C is days it to...
Percentage formula?
Hello, I have a column in a Micosoft Excel spreadsheet that contains Yes & No answers. Can anyone please tell me how do I find out how many Ye...
Compare and count two columns
Hello, I am struggling with a fairly basic excely problem. I have 2 colums Feb 2012 and Feb 2013 each have a number of different crime types...
Need a recovery software
Hello, plz send me recovery software for office file. E-Mail ID is deleted for your security Configuration: Windows 7 / Firefox 20.0
Comparing data in two columns and setting a value
Hello, I'm comparing data in a very big database. and want to assign a value to matching data. For example A B ...
Where to download free microsoft office
Hello, I would like to ask for help on where to find free microsoft office Configuration: Windows XP / Firefox 19.0
Excel search words from a cell and assign txt in another cell
Hello, I am having data like whi below: A B 1. customer1 TV Fridge ...
Macro - copy speciffic columns when value is x
Hello everyone, I've been having a problem for a while and seem to be unable to solve it. I am now trying to get it done with Macro's but run...
Percentage formula
ClosedHello, I have a column in a Micosoft Excel spreadsheet that contains Yes & No answers. How do I find out how many Yes answers I have compared a...
Excel macro copy/paste and insert rows
Hello, I am trying to write a macro that takes data from a filter and copy and pastes it into a template to create a standardized set of reports. ...
Date formant in excel sheet
Hello, how to solve date formant in excel sheet Configuration: Windows 7 / Firefox 17.0
Pulling data from multiple cell's in a series of spreadsheets
Hello, I have already done some searches for help on this but I don't think I am coming up with the right way to say it to search for it probably. ...
Excel macro
Hello, how can i create the alert excel macro when the cell is changed Configuration: Windows 7 / Firefox 18.0
Problem for creating ms word on tablet
SolvedHello, I find very difficult downloading MS word, Excel and VZO video chat.
Snding sms from excel sheet
SolvedHello, i need to send text message from excel sheet to mobile number. is there any method to send sms. please help me to give method. thanks ...
Transferring data from one excel to another
Hello, I am trying to transfer an array of data from several spreadsheets used by individuals to a "master" spreadsheet that will be stored on a shar...
License
Hello, Thank you the community in this forum, this is my first day in this forum after joining. I am still learning and think will get the best out ...
Formula problem
Hello, I am trying to use a tracking number ex: WP 2013-0001 on excel. I want it to generate in the row automatically with WP 2013-0002 and so on....
Dropdown lists in excel 2007
SolvedHello, I want to create dropdown lists in excel, it should work as follow:In cell2,1 must be a drop down list with 4 names (e.g.Mill,Comp,Loads,Blend...
What is the most appropropriate way to recover pst file
Solved/ClosedHello i m using MS Outlook my PST file was oversized which got corrupted after subsequent retrieval. Tell me what to use?? Inbox PST repair tool...
I need to replace jpg description with a number
Hello, I have thousands of jpgs that are named by a product description, like Beltwayjacketblack.jpg, and I need to replace jpg description with a p...
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 ...
