Hello, i am trying to use excel to give me two values depepnding if its a monday or a wednesday i have a date box so every week a person will pu...
Hello, I am wanting to compare two columns of information containing names from two different excel sheets. Names that do not appear on both list...
Hello, I have two worksheets. I would like to enter values in a column of sheet 1. When any of those values match a value in a table on sheet 2, ...
Hello, I Want to change date format dd/mm/yyyy to dd.mm.yyyy in MS Excel 2003 Please solve my problem urgently
=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!
Hello, I'm sure my question is simple to most of you as I'm new to UDF. I've created the following UDF but cannot apply it across columns when I us...
Hello, 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 ...
Hello, I am Having enormous difficulty with my MAC keyboard operating in Excel. I feel i must have put the scroll lock on but cannot find any ...
Hello, hi there i am just new to excel and iam trying to understand by praticing by own i want to copy sheet1 data to sheet2 when im typing in she...
I am trying to create either a formula or a macro (which I do not know how to create) so that the following rule works: (1) If last row of data (ie c...
I currently have 2 spreadsheets which show payments from 2 different companies. I'd like to be able to merge them into one spreadsheet which updates i...
Hi.. 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...
Hey 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...
Dear Sir I need help in a macro to create a new sheets with colum A name and copy row cells to the new sheet. Name Age Gender XX 25 M ...
Hi all, I have used excel for years but never at an expert level. I am currently in a position where I need to view multiple tabs of data daily to...
I am working on a spreadsheet and I need to transfer the ending balance on one page to beginning balance on another page, for the entire tenant list. ...
Hello, Good Afternoon, I need some help to be able to complete the below task. I need to be able to copy data for 2 different tabs in an wo...
Hello, I really need help trying to figure out this formula, as I have tried so many different formulas and can't seem to find one that works. I nee...
Hello, Here I have a filtered list from Master Sheet to DueReminder Sheet In which column I represents Email address Now my motive is to se...
Hello, In SAP BI I have created a BEx Query. We can see BEx reports in MS Excel. Date format in the report is DD/MM/YYYY and I want it to be displa...
Hello, I have two worksheets (1 & 2) that have different info, with not many duplicate records. I need to identify the duplicate records. I can ...
Hello, In one column - A i have name for eg -Anuj Muchhala and another column B - Anuj & column C - Muchala - I want to know how to match maximum ...
Hello, I have Excel 2011 for Mac. Is it possible to make a cell flash using the Mac version of Excel 2011? If so, how is it done? I would apprec...
Hello, I would like to ask for a macro (as I was unfortunate to experiment with a lot of them and none of them worked as I'd like). What it sho...
I use Excel to store information about several users and their cars information and have a different worksheet for each month. How to merge all these...
Hello, I've two columns like below and i'd like to replace the one in 1st column with the one in column B in another table. Name_A Name_B Joe ...
Hi, I have a data in sheet1 with ID, name ,area, amount,January amt,February amt.....(below month column particular dates are mentioned) Anybo...
Hello, 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...
Hello, I've got a list of products for an e-commerce site. What I'm trying to do in Excel is flag any items that have a quantity of zero AND are i...
please clarify my problem "convert numbers to words in excel"
Hello, I have the problem of having all the 4 date formats in the very same column: mm/dd/yyyy dd/mm/yyyy mm-dd-yyyy dd-mm-yyyy I would nee...
Hello, Dear to whom it may concern, I want the data in sheet 1 to automatically export the data in sheet 3 and when the row is empty in sheet 1 th...
Hello Trowa Sorry to bother you again but a problem has arisen. Everything was working OK until I tested "Pair names 4" Column Q. When I ran the code...
Hello, my English is not good, so I'm using google translator, sorry about that. I am creating a spreadsheet where is the organizational chart of...
Hello, 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...
Hi guys. I have two sheets and would like to compare sheet2 with data in sheet1 and copy a cell data from sheet1 to sheet2. Eg: SHEET1 A ...
Hi All, I was preparing an excel workbook, based on the sales pipeline. To simpify, The first sheet has company name and contact column. Titled "...
I am currently creating a wage calculation template in excel. There are 3 sheets currently in my file. First is "employee information". Second is "emp...
from excel file to excel file, how can I get comments updated automatically, similar to vlookup or hlookup? i.e. comment in cell c4 of file abc.xls...
Hello, In Excel , I want different format for formula result in one cell. A1=0 & A2 = THANKYOU =if(A1=0,"OK","NOT OK")&RIGHT(A2,5) ----...
Hello, I would like to know if there is a way to apply a format formula to a cell but to use a letter as criteria instead of a number? Example:...
Please help. I want to make an excel sheet in which i can copy one whole column onto the another column in all my sheets of master sheet. For exampl...
Hi 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 ...
I am trying to create a macro of some sort to do some checks to make sure everything is populated correctly. Here is an example of the spreadsheet... ...
Hello, I'm trying to write something that will copy and paste cells AC10:AQ15 from a sheet called "Format" to the end of column AC on the sheet ca...
Hi, I have a data in sheet1 with ID, name ,area, amount,January amt,February amt.....(below month column particular dates are mentioned) Anybod...
Hi, Ive been searching for a way to count a list of names as a number. I currently have to place a 1 in a column next to the list of names. And have ...
As 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...
Hello, I have a spreadsheet of 500 rows. Each row contains on unique "item Number". I am looking for function that will locate the unique number i...
I want to know if its even possible to create a Macro whenever I copy/paste information that is provided to me weekly, which in this case is in th...