Excel Forum
-
How to insert multiple conditions in a formula? [Solved/Closed]
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...
-
match the same no of data1 with data2 with respective qty and pr [Closed]
data2 data1 partno qty price partno qty price 0411175858 4 411.00 0437160070 5 89.50 0...
-
Excel - Shortcut key print preview [Solved/Closed]
Hello, What is the short cut in excel 2003 for print preview. Please give me solution. Configuration: Windows XP / Firefox 3.6
-
Multiple Results with simple criteria? [Closed]
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 ...
-
Insert word in cell based on value in another cell? [Solved/Closed]
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 ...
-
Round UP Formula for TIME [Solved/Closed]
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-...
-
Formula for percentage calculation [Closed]
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...
-
Formula Assistance [Closed]
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...
-
The value of a name [Solved/Closed]
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 ...
-
Excel Conditional Formula [Closed]
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...
-
how to find positions with repeated marks [Closed]
Hello, Sir i have problem with finding positions of a class having equal marks can any body help me please. Configuration: Windows 7 / Interne...
-
Adding rows based on Users selection [Closed]
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...
-
Macro to copy worksheet based on criteria [Closed]
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...
-
how automate to search and move data from one excel to another [Closed]
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...
-
Copy data from one work book to another [Closed]
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...
-
Can the formula COUNTA / COUNT exclude 0 values? [Solved/Closed]
If I use COUNT or COUNTA, what can I include in the formula to exclude zero values? Thanks for any tips
-
Drop down list opens new window [Closed]
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...
-
Populate cells based on criteria... [Closed]
Hello, A B C D E F ...
-
Transfer data into Invoice [Solved/Closed]
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...
-
If Functions [Closed]
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"...
-
Inserting a row when the value of a field changes [Solved/Closed]
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 '...
-
Format cell color based on date range [Solved/Closed]
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...
-
concatenate cells losing comma formatting [Closed]
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...
-
formating cells [Closed]
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...
-
Simple Point of Sale [Closed]
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...
-
VBA to put formula into cell [Closed]
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...
-
Excel [Closed]
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...
-
VBA Macro to export data to a new workbook [Closed]
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...
-
VBA - criteria lookup and the removing formula from cell [Closed]
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...
-
Filtering data from 1 sheet to another [Solved/Closed]
Hello, I have the following problem. Kindly help me with the same: Problem statement: I have data pertaining to projects, milestones and tasks ...
-
If row is checked copy it onto next available row on 2nd sheet [Closed]
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...
-
If formula using dates and texts [Closed]
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).
-
Using a selected criteria to copy cells into new sheet [Closed]
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...
-
To show blank record when no data while copying [Solved/Closed]
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...
-
add value to one cell if multiple other cells have any value [Solved/Closed]
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...
-
How to auto merge same value cells. (H\V) [Closed]
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...
-
Change content of one cell based on content of another [Closed]
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...
-
Collect data from drop-down list from multiple workbooks. [Closed]
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 ...
-
How to go to a particular cell while input its content in a box [Closed]
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....
-
Filtering and copying data from one sheet to another [Closed]
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...
-
Conditional formatting for cells depending on other cells ranges [Solved/Closed]
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...
-
macro extracting data from different sheets within a workbook [Closed]
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...
-
How to see if a particular cell in a table has date data or not [Solved/Closed]
Hello, I am preparing a tracking tool to measure the life of an item. The table has Installation No Date 1 ...
-
formula calculate daily income in excel [Closed]
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...
-
Highlight the linked cell depends on drop-down list choice [Solved/Closed]
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...
-
Conditional Formatting: Merged cell color [Solved/Closed]
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...
-
Calculating Due date based on multiple criteria [Closed]
Criteria 3 products, choose one classification, one category, all time frames are different Products: HBX, Flex, NYM Categories: Complaint, Gvn...
-
duplicate values at the bottom, not at the top [Closed]
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...
-
Array formula to nest several optional values from same cell [Closed]
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...
-
Counting cells containing only numbers [Closed]
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...
Subscribe To Our Newsletter!
