Search results

Hi. In the attached workbook, I have three columns of numbers. I am looking for a formula please that will arrange column B in descending order, but always moving the accompanying row value in column C as well when it resorts the order. Where two successive values in column B are the same...

Hi. I am struggling to create a formula that will track the first occurrence of a given name, but always in conjunction with a further cell value, and would really appreciate someone devising a formula-based solution that I have been unable to find. Please see the attached spreadsheet. I have...

Hi. Please see the attached sample from a much larger Excel database that I am running. I need to extract all of the teams that each player has appeared for (as compiled from the Appearances tab), and list them in columns B - G on the Summary tab. I can determine the first occurrence easily...

Hi all. I am looking for the correct function to use that will add the values present in a number of rows in the same column, but only if those rows share the same value in another column. For example, Column A has a number of values, each of which repeat down several rows, while Column B has...

Hi all. I need help creating a formula please, which will not get hung up only on the first instance of a number if there are multiple instances of that same number. I have a list of names in column A and a list of scores in column B, and am trying to get a formula to list the scores from...

Hi all. What is the easiest way to get Excel to use the result of a formula to find the correct row in a table, and then copy the cell contents of a cell in that table row? In short, I need it to look at a formula result (e.g. "L17), find the specific row in a table that has "L17", and then...

Hi. I have a spreadsheet database consisting of a series of events, each of which has a unique identifying number and a date. I also have a list of names of people who have attended these events. Is there a formula anyone can give me that will allow me quickly to determine the longest periods...

Hi. Getting very frustrated and would really appreciate some help from the Excel ninja gurus please! I have an Excel 2010 spreadsheet being used as a database, which includes inter alia a range of columns containing numbers. When originally entering the data I left blank cells in these...

Hi. I have embedded thousands of fully-functional Excel spreadsheets into Word documents over the years, but have now suddenly hit a blank. For no rhyme or reason though, when I now double-click an embedded spreadsheet I suddenly am no longer getting the usual Excel ribbon displayed. Can't...

Hi all. I have create a UserForm with 47 checkboxes on it, each obviously with a different caption, as well as a textbox for user free text entry. The requirement is that a user enters text (a policy number) into the text box, selects however many of the checkboxes apply to it and then clicks...

Hi. Need some advice please. I have a Word document that contains numerous embedded Excel spreadsheets. When I try to edit the content of these embedded spreadsheets, I get the error message "The program used to create this object is Excel. That program is either not installed on your...

Hi. I have a current SUMPRODUCT formula in a spreadsheet that is working adequately, but due to also being nested in a series of IF formulas, it is cumbersome and not very flexible. I now wish to amend it to incorporate new selection criteria, but have run into issues with the number of...

Hi. I am struggling to create a timesheet with formulas in Excel that will keep a running debit / credit time balance for myself. I am using the TIME function to factor my 45-minute Lunch hour into the the end time less the start time calculation, in order to determine the total number of...

Hi. I downloaded and installed the Power Pivot add-in for Excel 2010, but thereafter I couldn't seem to embed editable Excel spreadsheets into Word documents anymore (which is a very important functionality to me). Is this a known Power Pivot issue, or did I do something wrong? Thanks.

Hi. I need some help with the attached extract from an Excel database please: https://dl.dropboxusercontent.com/u/92056659/Database.xlsm This is part of a much larger database tracking club cricket player performances. What I specifically need is a way for the "Indiv Fielding Pivot Table"...

Hi. I have a column of numbers, some of which are whole numbers and others of which have one decimal place. Is there a formula that I can apply to the entire column that will differentiate between the two number types, and then work differently with each type (I am thinking formula-based...

Hi. Can anyone assist please? I have a column full of names (call it Column A), many of which are duplicated many times over. Can anyone come up with a formula that I can place in the column alongside (Column B), which will a) search Column A for any duplicate entries that match the name in...

Hi. Shrivallabha was kind enough to help me in my previous post "Need a COUNT formula with multiple AND and OR criteria" with solving my issue to develop a formula that counts the number of records in a table that simultaneously complies with multiple compulsory and optional criteria. To...

Hi. I need a formula that will count the number of records in a table that simultaneously complies with two different compulsory as well as either one of two optional criteria. In other words, it must count the number of records in which the Product ="Endowment" AND the Branch ="Cape Town"...

Hi all. I can't upload a sample file, so hopefully the following explanation will suffice for a solution to be forthcoming from someone here. I have a spreadsheet where row 33 contains month-by-month totals for 2011 (cells B33: M33 for Jan to Feb), while cells B34:M34 do the same in row 34...

Hi. I have created a fairly large Excel "database" that consists of several worksheets, each containing a different type of data about the same people. There is also a fair degree of overlap between the worksheets due to generic info that appears on all of the worksheets (i.e. the same...