forumla

Hi all, I am trying whole day how to copy cells, please help, here is what I try to do. I have data A B C and want to copy to another worksheet in this format A A A B B B C C C so when copying it puts "A" three times and moves to next cell.

I have an issues with trying to pull the correct data. My scenario is I have an employee number with a worked date next to it (tab 1). I also have a tab (tab 2) that shows by employee number when an employee was active. The issues I am having is on this tab his active status could be multiple...

Hey! I am a tax accountant trying really hard to impress my manager...long story short one of our big clients give us a very un organized Excel sheet of there trial balance... and I want to find a quick way to organize it...below is an example of what the excel looks like and what I want to...

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...

Hello, I am attempting to create a drop down list (data validation) and depending on what the user selects I would like have another cell run a calculation summing different values based on that selection. Unfortunately there are too many choices to warrant doing a simple IF statement so I...

Hello, I am hoping somebody could assist me with a conditional formatting formula. What I am trying to do is if the value in cell M136 is greater than $3.00 or less than -$3.00, then my formatting takes place. I'm jut not sure how to go about writing this formula

Hello all, Is there a way to have the format of a cell set to display degrees? I have the formula = A12 in the cell, but I want the number to appear with the degree symbol. Any possible way to do this? Thanks

Hi , I am in the midst of fundraising for a Gala Day and I need to creat tickets for a bingo tea. I want serial numbers on them to avoid counterfieting. (Yes, it is that type of place) I am looking to have the serial number in Column E Due to the text the Rows are likely to be 4,8 , 16 etc...

Hi There, Need abit of help counting the ammout of days between two date. Lets say i'm using A1 as the start date and B1 as the end date. I can do it simply by using =B1-A1 and that will return the days. What I need to do is this. Start date in A1 and if there is no end date in B1 then it...

I am trying to set up a couple of basic formulas to track changes. The B column will have the current number each day, the D column should track daily change (B2-B3 is what D3 lists) and the E column tracks cumulative change (referring to B2 as the starting point). I've set it up so that it...

Good morning everyone :), I'm trying to write a match forumla but keep getting stuck and was wondering if anyone here could help. I want to check 3 columns (1 - 3) and if they match then return the value in the 4th column; Col1, Name = Barbara Col2, Sheet = Shoes Col3, Code = 123 Col4...

Hello,<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p> <o:p></o:p> I am working with EOMONTH and a few other functions. But can't seem to work out how to get last working week.<o:p></o:p> <o:p></o:p> I have a Marco that opens some template wbs, pulls data...

I'm having a heck of a time trying to figure this out but I want to make a bar graph that shows unit price and units sold over a given time. Here is an example of my data Year Qty Unit Cost 2005 10 $10,000 2006 30 $8,000 2007 50 $7,000 2008 100 $6,000 2009 250 $4,500 Basically I want two...

Dear Excel Experts, Forgive me if this has already been asked, but I've searched for a solution for my problem without much success. Everyday at work, I have to do a data sort by three categories. After that, I have to manually put in extra blank rows to separate one specific column. Is...

Hi, All my data is in Column A as shown below. Each line is a different row. Each addresses may be a different number of rows. How can I transpose several thousand of these addresses into columns, knowing that each addresses a varying number of rows. I don't mind modifying the addresses after...

Hi, I want to anylise some data in excel, the data comes from a dump from a database Region, Days open, Ticket Number I am try to create a formula that goes and counts the number of instance in each region so. I will have multiple entries Region, Days open, Ticket Number America 10...

Hi, I'm trying to pull historical data for a currency pair from bloomberg at a single point in time, but I keep receiving an "#N/A History" error or the values appear as 0. The formula I currently have is: =BLPIT("USDGBP Curncy","Last_Price","15/07/10 15:00") If anyone could help me on this...

I have 4 summed values in seperate columns and I want to run an if statement based on the max value of the 4 columns and if the IF statement is not true then run a formula to get the weighted average of the remaining the 3 values. Ex. 66, 75, 41, 39 ( there are columns in between the values as...

I am trying to use the following formula to hyperlink to a cell in another workbook. I am looking up the cell I want to go to using =ADDRESS(MATCH(A15,[LCIREDFLAGNOTES.xlsx]LCI!$A:$A,0),1,4,1) Then I want to hyperlink to that cell in that workbook. I have tried alot of different stuff but...

Hi All, New to this but i heard this was the place to find answers to my excel questions. Ok so here is what i am trying to do. On one sheet it has a table which has the results to football games On the same sheet it has the peoples predictions On the second sheet it has a League table. On the...