multiple columns

Is it possible to delete cells rather than rows/columns? I will have 2 columns of data (peoples names) what im wanting to do is be left with the same 2 columns of data WITHOUT the duplications. eg Current Names List......New List of Names Bloggs, Joe ................Smith, John Brown, Jim...

Hello All, I'm currently conducting UAT and need to find a way to automatically track our metrics. We have a number of procedures, each represented by a unique code. Each code may have multiple steps and therefore multiple lines in the database. Each step has it's own status. See sample below...

Hi All- I'm looking to create a formula that I'm not sure is possible. In my spreadsheet template I have company departments in Column C4:C500 and projects in rows F3:AZ3. The actual proj ID in F3:AZ3 will vary by spreadsheet, but I have a separate Master sheet that has all projects and all...

Hi All, I have a question that is stumping me! I use Excel 2003 (but present to other using 2007) on Windows 7 (others use 2000 & XP) I need to present the following: Extract ONLY records (row entries) that have had training between certain dates (for a month end audit). Everyone has a...

Hi All I have 2 sheets: Sheet 1 - all employee information Sheet 2 - list of select employees that failed to attend training course last week Sheet 1: Pay # / Employee Name / Attended? 12345 / John Smith / Yes 12345 / John Smith / No 12345 / John Smith / No 12345 / John Smith / Yes 45678...

I need a little help with the sumproduct formula. I have this data which gives the travelling patterns of people living in certain city. For each trip, all the modes they use are tabled in separate columns in the order of use, also there is a column for the purpose of travel which are...

I have a database with multiple columns named age, sex, occupation etc. I need to make multiple tables from this data on a separate sheet. One example is: Age Category No. of Males in the category No. of Females in the category 0-3 4-5 6-9 10-15 16-21 22-24 Taking the same...

Hi everyone, I'm a newbie to this whole Excel thing, but now I have a huge headache trying to figure this puppy out, so any help you can offer would be awesome. I have an excel sheet with 6 tabs, all containing different data, some text and some numerical. I need to perfect this formula to...

I have several rows of data that contains data in the following format. 123, abc, 456, def, 789, What I would like to do is Concatenate them all together to get the result 123,abc,456,def,789, I have a total of 100 rows like this that I am trying to concatenate. I have tried all sorts of...

Hi everyone. I have what is probably a very simple quesion, but despite having spent the morning searching online and trying formulas I can't get anything to work. :confused: I have a simple spreadsheet to track people booking onto events. Columns A to G cover personal data, then we capture...

I have a dropdown list in my spreadsheet that identifes a code. The code does not mean anything to the users of the spreadsheet so I want to include a description with each item on the list, BUT I do not want this description to be included when the user selects the code. For example, I want...

I am trying to select multiple areas for the x values in Linest. Below is what I tried =LINEST($B$2:$B$43,(C2:C43,E2:E43)) Does anyone know the correct code? Thanks

I need to build an Access 2007 report for comparing property sales. The field names are PropertyName, CityName, Community,SqFt, LotSize, Age, DateSold, Price. The report will need to be a side by side comparison where the user selects the properties to be compared and the report will have the...

I have two tables. <table style="border-collapse: collapse; width: 108pt;" width="144" border="0" cellpadding="0" cellspacing="0"><col style="width: 35pt;" width="47"> <col style="width: 40pt;" width="53"> <col style="width: 33pt;" width="44"> <tbody><tr style="height: 15pt;" height="20">...

Dear members, I have excel 2007 sheet as follows:- <a href="http://www.flickr.com/photos/indianbiker/3945338417/" title="untitled by IndianBiker, on Flickr"><img src="http://farm3.static.flickr.com/2497/3945338417_33bc904ee4.jpg" width="500" height="313" alt="untitled" /></a> As you can...

I'm using VBA to sort columns in Excel 2003. I need to sort by column 5 ascending, then column 3 using a custom order, then by column 4 ascending. I'm having difficulty getting the sort to work and I don't totally understand how OrderCustom applies. Could anyone point point me in the right...

This should be fairly simple, I need the VBA code to return only the first row number in a range as a variable where columns B and C meet my criteria. e.g. Column B criteria = 1 Column C criteria = 0 <TABLE style="WIDTH: 284pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0...

Hi, I have a data table with list of products going down the row and weekly sales values going across the columns (4W3=Apr week 3). I'm trying to do a sumif formula (WITHOUT using Pivot Table) that will give me a sum of: Apple sold in total month of April (columns C+D). Tricky part is, when we...

Hi all. I'm a newbie here. I have this worksheet. What I have here is one activity ID with multiple information on BOQ and its related data. What I would like to have is just Columns A-J and move the required information in columns K-AS to H-J. The result of this will give me multiple rows of...

I posted for the first time a little while ago and was pleasantly surprised with how fast--and awesome--the response was. Silly me, I really should have asked what I'm about to post here but I honestly don't know if this entire copy and paste project can be turned into a macro. So here goes my...