problems

Hi All, I am trying to use a mode if for text data. It is a variation of this array formula i am looking for {=mode(if(Table1[x] = C2, Table1[y]))} but having problems. Any help would be much appreciated. Thanks

I do various work in Excel for electrification, but recently I had a problem with Excel 13 when opening a file with one important table that I had to send to an engineer of one construction company. I've been using Excel 2007 for quite some time, but our office has moved to the 2013 version. The...

All users concerned are using Excel 2016. On my computer, I have the Power Pivot add-on while audience doesn't. When emailing my report to my audience, as soon as they select a something in the slicer, they encounter this error: The query did not run or the Data Model could not be accessed...

I have the following code to delete a row if the value in column C is Monday. My question is, if there is no Monday value will there be an issue, so far I have run the code and I do not see any problems. Is there an alternative. Thank You Code Sub DeleteMonday() Dim lr As Long...

I am having problems using a SUM formula as par of a SUMPRODUCT formula. The formula is as follows. =SUMPRODUCT(--(D4:D12="Apples");SUM(E4:F12)) What i am trying to achieve is that it multiplies the 0 or 1 resulting from the D4 check with the sum of E4:F4, then the 0 or 1 from the D5 check...

Hello, I recently had stability problems with some code and it crashed Excel mamy times. Now when working in the VB edditor the VBA project tree has duplicated the sheet and workbook objects (although the new objects have no code). I have sheet1, sheet11,sheet111, sheet1111(logooutput) etc...

I have just taken over a spreadsheet previously managed by a colleague. It's very simple--just a database with columns (last name, first name, address, etc.) No functions, no formula. It was saved in Excel 97 as recently as last month. I have managed to clean up lots of formatting, but I keep...

I'm trying to create a randomly generating maths drill file for students My file to date is NOT attached - I can't figure out how to do it. :eeek: I did search "attach file to post" but couldn't find how to do it To start with I want the students to be able to choose if the problems will be...

Hello, I am currently working on a project and I am in need of excel assistance. I have a sheet that has a lot of client data (e.g. name, date of assistance, reasons for seeking help). In another sheet, I am gathering data with regards to all clients. For instance, I want to know how many...

I have 2 sheets. The first sheet has the data and the second is basically a summary sheet. Here's what I need to do: SHEET 1: DATA SHEET <tbody> Model Code Model Description EBQ Code EBQ Description QTY Export Total LIGHT FITTINGS: PS0050 Light - T5 Recessed Fixture 2x28W 1200 x 600...

Where I work there are lines that are going out of stock more than once a week. We have recorded how many times they are going out of stock and I have to come up with a sheet that records the top 10 lines that are going out of stock the most frequently. My spreadsheet is set out with unique ids...

Hi, I'm trying to find the point of diminishing returns on some econometric data we have received that shows money invested to bookings made. To do this I have been trying to find the equation of my curve in excel. I've seen a few other posts about using the LINEST function to do this, but...

hello i have created a userform , the function of the userform is like first when i enter the value it will be entered into the sheet with specified rows then next if enter just few fields it will copy the value of cell above and paste on the current cell.When i run the program it works...

I have some trouble with this Code, and i don't know why it's not working?? If Sheets("Counting").Cells("R4").Value = "Amount 2014 - 4" Then Sheets("Counting").Range("S4:W4").Copy Destination:=Sheets("Overview 2014-4").Cells(Rows.Count, "Q").End(xlUp).Offset(1, 0) End If i get...

=IF(WEEKDAY('WEEK 37'!M3,2)=1,WORKDAY('WEEK 37'!N3+4,0),IF(WEEKDAY('WEEK 37'!M3,2)=2,WORKDAY('WEEK 37'!N3+3,0)),IF(WEEKDAY('WEEK 37'!M3,2)=3,WORKDAY('WEEK 37'!N3+2,0)),IF(WEEKDAY('WEEK 37'!M3,2)=4,WORKDAY('WEEK 37'!N3+2,0)),IF(WEEKDAY('WEEK 37'!M3,2)=5,WORKDAY('WEEK 37'!N3+1,0))) So I want the...

Hi! I was trying to use COUNTIF in a named range as it's explained here: Excel Magic Trick 185 Dynamic Formula Extract Data 1criteria - YouTube, but I receive a non descriptive error message as mentioned here: Ctrl + Shift + Enter: Excel Array Formulas 12: SUMIFS, COUNTIFS, SUMIF, COUNTIF...

Good morning, I am facing a dilemma that I cannot solve. When I run the following code, the Order By in the Select Statement is not respected and the data in the table is not entered in order. When I run the Select statement by its self in the "Query Designer" it shows the records in the...

I have used Logmein Free for 5+ years and always found it great for most purpsoes. There were some issues (like the way files opened in windows explorer) that seem to have gone away. The main issue that stops me working in Excel at home on my work files are when I need to work in group...

I know there is a way to use an array formula for this. Essentially I have data ranging over a 9 year period. The data starts in certian years and ends in others. I want to write a formula that would say if the data starts in 2008 or later show the numbers, if not show zero or n/a. Here is an...

I have put the Frame Control on Excel Sheet and Add Textboxes and Labels to it . Now I want to Send data to Frame Controls(Textbox) from Excel Sheet By a Click of a Button. What is the Procedure to do it? Thanks in Advance