help me

My last resort! I hope someone can help. I am working on a formula but I just can’t quite get what I need! So far here is where I am at: =IF(MEDIAN(G:G)>G2*0.8,"Yes","No") What I need it to do: IF C:C has MULTIPLE of the same Text then it will calculate the Median of the numbers in G:G, (and...

Hi All, I currently have a list of companies and their corresponding company ticker symbol. I want to be able to choose either the ticker symbol or the company name from a drop down and have a corresponding cell populate information. For example if I select "GE" from a drop down list I want the...

Ciao everyone. i've searched some already existing question like this without any result, so here my first topic. sorry for my english, i know is not really good. I have a column of vallue calculated from other cells operations. i have to find a way to create a new list of them oredere from...

Hello to all! Here is what I need help with and ill use examples: on sheet1 I have Column A(names) and Column B(address) on sheet2 I have Column A(names), B(address) and C(city) if the names and adress match I need it to show C(city) on sheet1. If there is no match then it is left blank...

Im stuck! What I am trying to do: If cells from spreadsheet1: C1 and E1, match cells on spreadsheet2:C1 and D1 it will show spreadsheet2s data from cell E1. Thank you in advanced for your help.

I am having problems trying to "share workbook" every time i do it pops up 'This workbook can not be shared because it contains Excel tables or XML maps. To share this workbook, convert the table ranges and remove the XML maps.' i have converted the tables to range and i have looked into the...

I will start this by saying I don't know much about excel, but I do know that formula for this problem is beyond my skill level and beyond what a simple Google search will answer. The challenge is: I have 5 areas (Cans/Contingent/Kegs/Maintenance/Bottle) that submit daily codes (20 different...

I've been pulling my hair out all day... so I figured I should finally break down and ask someone. I keep a spreadsheet for my bills (who doesn't, I know). On it, I've always either copy/pasted the "Amount" in the applicable cell for when a bill is due, or a cell reference (in case it changes...

I'm horrible with describing my problem so hopefully I will get this out right. I have a table in which I track packages with and each one has a unique number. If someone returns a package on multiple dates (i send a quantity of 500 papers, they return 200 today and 300 tomorrow), i'm tracking...

Hi, I am not even sure the type of formula that I need but I need to be able to copy something from one column into another column based on the value of a column... This probably makes no sense so I will explain with a picture.. Column A Column B Column C 100 Address1 200...

Hi All, Please help... Scenario: Basically I have a a spreadsheet with Raw data on 1 page, list of places, and a table/results sheet. I currently manually go through the raw data and decide whether each line is proactive or not. I would like a formula to do this for me, by searching a...

I've got maybe average excel skills but no VB experience (which I probably need to pick up) and I have a bit of a challenge in trying to produce a report that is easier to read than what I have now. I inherited the employees and processes around this workflow and so while I have limited control...

HELLO GUYS, COMPLETE BOG STANDARD EXCEL INTERMEDIATE HERE! I HAVE AN ISSUE WITH A PROJECT IM WORKING ON, IF ANYONE HAS A SOLUTION PLEASE LET ME KNOW :) OK I HAVE A DOCUMENT WITH MANY SHEETS, I WOULD LIKE A SHEET TO MATCH TWO CRITERIA OF ITS OWN CONTENT, AGAINST ANOTHER SHEET THAT CONTAINS...

Pretty new to excel so bear with me. Have to complete a table that responds to different values. I have a basic formula that is: =B18/B16*60 and i want it to be able to change in response to another cell and look like =(B18/B16*60)*B19. However I want B19 to be left as zero without making the...

I am working with a number of (weekly) tabs within Excel and find myself going back through these tabs to look at information. So say I am looking at 'Bricks' (column B) which has a code of 025 (column A), is there a way of making all the tabs locate this cell without me have to scroll to the...

Hi! I would like to seek some help on macros unlocking selected locked cells using macro. By default, all cells in my worksheet are protected/locked because, I would like my colleague to use the macro feature of my file. But the problem is, I do not have any background on macros. Can anybody...

Hello Guys, I Need ur Help ,as i m not a Programmer I dont knw more abt macros. i need your help to make me a small program like https://www.dropbox.com/s/1z0f9ip4qydan1d/PartLocDBComboAdd.xlsm I Need it like this https://www.dropbox.com/s/c10mq3h3rir5fc8/This%20is%20the%20way%20i%20want.png All...

Hi people, I'm pretty new to vba and keep getting a run time error 1004 on the highlighted line when i run the following macro... <code> Sub auto_open() Dim cwb As Workbook Dim arow As Long Dim brow As Long Application.ScreenUpdating = False Set cwb = ThisWorkbook Sheets("Domestic...

I have not used access much in the past and I have just been given a task to provide a solution to a problem. The problem is that a University has a lot of members of staff in one department. Each one of those members of staff teach quite a few Modules (Subjects) and each Module is taught by a...

Hi Guys, I am new to both this forum and excel and in need of some help. I have created a pricing table (Please see below and you are charged per unit in a tier structure. For example if I purchased 13,500 units, I would be charged 0.21 per unit for the first 10,000 units and for the other...