I have 2 cells, and I proceed like this with a formula and basically, if cell A2 meets a condition, then cell B4 shows the word "Good" =IF(A2>=100...
data2 data1 partno qty price partno qty price 0411175858 4 411.00 0437160070 5 89.50 0...
Hello, What is the short cut in excel 2003 for print preview. Please give me solution. Configuration: Windows XP / Firefox 3.6
Hello! Here's what Tab A looks like: Cap Type 220 N 3993SNB34 180 N 7113038KH34/32 220 N WS450BKXL 100 N ED303BK38/32 180 N 874OG36/32 ...
CONDITIONAL FORMATTING for cell A2: if value in cell C3 is > than 500, then insert word "alert" in cell A2 what would the formula look like? I ...
Hi All. I need an excel macro to populate a cell with a time slot based on the previous column which is a datetime value. e.g. if column A is 1-Apr-...
Needed a formula in A which will be then pulled down throughout the column. Wanted the result in A where B multiplied by C & D and deducting the val...
Excel..... I have a spreadsheet for shipping products. When I enter the amount shipped, I would like for that days date to appear in the next column...
Hello, I've been playing a lot of dark souls 2, and I'm trying to make a spread sheet to have the value for armor (to start). I plan on making ...
Here is my need. I have a visit date that I want to prepare for 3 weeks in advance. So if I have a date of 5/23/14 for the visit I want a cell to show...
Hello, Sir i have problem with finding positions of a class having equal marks can any body help me please. Configuration: Windows 7 / Interne...
Hello, I want add rows with say Y1,Y2,Y3...Y10 based on what value the user selects from the drop down i.e. Say a user selects 5 then in the o...
I am fairly new to using macro's. I have 4 template worksheets and one input worksheet. Based on cell c4 in input worksheet I want to select either te...
Dear Friends, I need a excel script to search columm A data from my lslpp-report and match the phrases in column A with the data from the lslpp raw...
I am a beginner in excel so i need your help on this. The 2 work books in question are the links below. https://docs.google.com/spreadsheets...i...
If I use COUNT or COUNTA, what can I include in the formula to exclude zero values? Thanks for any tips
I would like to create an excel that has a first sheet with drop down selections $2m >$5m >$7m Depending which is selected a different excel she...
Hello, A B C D E F ...
So I've put hours and hours into this with no avail. Here's my situation...I have on "Sheet 1" a list of materials which could potentially be used dur...
Hello , I am able to create multiple if functions ( =IF(Site1!H2="y",Site1!G2,IF(Site1!H3 ="y",Site1!G3,IF(Site1!H4="Y", Site1!G4, IF(Site1!H5="y"...
I was using this code as a start but can't seem to mak it do exactly what I want. Sub InsertRows() Dim r As Long, mcol As String, i As Long '...
Hi, this is my first post. I'm glad to be a member of this forum. Based on conditional formatting, how can I select a cell and have the backgroun...
Hello, I am trying to concatenate multiple number values into 1 string text, but I am losing the Comma formatting. Here is an example of 3 valu...
i am trying to change the colour of a cell based on the value of two other cells in Excel 2010. for example if R1 is the same value as C6 how do...
I have a relatively simple task that I'm hoping I can accomplish in excel. I'm putting on a college fundraiser selling four items and I have a list...
Hello, In a effort you keep you guys challenged. And obviously improve my VBA writing skills...I really appreciate all the responses I have had up...
Description: 1. I have an excel workbook containing multiple sheets (about 28-33) eg. Book1 and the worksheets are labelled eg. 01-March DS, 02-Marc...
Hello all, Trying to create a macro in VBA but getting some problems starting with it. If you can help it would be great! Going to summarize wha...
Hi, Could someone help... I have written some code but cant get it to do exactly what I want, and think I have over complicated the problem. Ce...
Hello, I have the following problem. Kindly help me with the same: Problem statement: I have data pertaining to projects, milestones and tasks ...
Hi Excel Folk and Friends of Michael, I have sheets and sheets each day of potenital 'buys' - when I get one I like I have to copy it onto another sh...
I want to write a formula which will show either Q1, Q2 Q3 or Q4 depending on the date I the next cell (written as 01/01/2014).
Hello, I have written a spreadsheet that is basically a dashboard for data... I have hit a small snag as usual the business wants to over compli...
Hello, I have three sheets sheet1(Active) ,Sheet 2(Inactive) and Sheet3(Total). I have written code which would copy data from Active sheet ,th...
Hello, I'm trying to create a spreadsheet where: if A1 has any value, 10 is added to the total sum in G1 if B1 has any value, 20 is added to t...
Hello, I want to merge same value cells in both rows and columns. for example i'll be having: | 2 2 2 2 2 3 3 3 3 3 | 2 2 2 2...
Hi! I'm looking for guidance on a formula/macro/etc that would enable me to have content of a cell changed based on the content of another cell in the...
Hello! I have a question. Let say, I have workbook 1 (WB1), workbook 2 (WB2) and workbook 3 (WB3). All basically are the same workbook, just that ...
Hello Trowa & Experts, I have an excel data sheet with columns 250 odd. Column headers have numbers like 100,101,102,103 and so on till 250 plus....
Hello, Problem statement: I have data pertaining to projects, milestones and tasks in sheet1. I want this data to be filtered on the basis of miles...
First off, I am not even sure if i worded my question correctly, so sorry if i have. What i want to do is... have for cells b4:b7 to have on green ce...
I need help creating a macro to copy data from multiple sheets within a workbook into one master sheet. I have tried several times and remain unsucces...
Hello, I am preparing a tracking tool to measure the life of an item. The table has Installation No Date 1 ...
I'm using excel to calculate my income and expense on monthly basis using sum() but I need to calculate daily basis. my data as follows A1 = 1-Ap...
Hello, I have a question. Let say I have a table containing number 1,2,3,4 and 5 in A1:A5. In another worksheet, I have "Student" in A1 and "Asses...
Hi, This is probably an easy solution but for the life of me cannot get this to work. I have a situation whereby I have a line of information th...
Criteria 3 products, choose one classification, one category, all time frames are different Products: HBX, Flex, NYM Categories: Complaint, Gvn...
Hi , The below formula gives me the results for AT column at the top of each duplicated code in column AJ. How could I make it to give me the results...
Hi, All the OR statement formula below refers to the same cell AL2362. How could I make an array formula to put all the OR values in one without r...
Hi all, counting cell containing only numbers Is there a formula to count only cells containing any numbers in general? Moreover, is there a formul...