suggestions

I need to add together the SUMPRODUCT from 5 sheets. I have tried a few things (,, --,+,AND, repeating SUMPRODUCT). This is what makes most sense to me, but it does not work...

Hi all, I've had some brilliant help from here recently - thank you :) But have now encountered another problem. At work we are sent reports from automated from systems (not owned by us) We can manipulate these reports pretty well but there is one aspect I cant solve myself. One column of...

wasn't sure what to title this. If i have data as such <tbody> Name Score Ian 1 Ian 2 Ian 3 Ian 4 James 1 James 2 James 3 James 4 John 1 </tbody> What I want to see is this <tbody> Name Score 1 Score 2 Score 3 Score 4 Score 5 Ian 1 2 3 4 James 1 2 3 4 5 John 1...

We have multiple files in Lotus 123 Version 9.6 with macros to link/update files. Any suggestions?

HEY EVERYONE WOULD LOVE YOUR HELP CTRL+SHIFT+ARROW DOWN STOP WORKING, any suggestions why is that? i forgot to mention that is the only shortcuts that stopped working...

I have a Combo Box on a UserForm named ComboBox1 with auto search suggestions i.e. if i type letter "a" it shows a list starting with letter a e.g. avocado, apple, almond, apricot etc. If I use keyboard down arrow key to select one of the shortlisted items, it selects the first one item and...

Happy New Year all Today I have been attempting to apply the following formula (Highlight Min Value) to a range of columns (A:F) using VBA any suggestions. =(A1<>0)*(A1<=SMALL(A$1:A$50,COUNTIF(A$1:A$50,0)+1)) Could use small without looking for values <>0 Thank You

Good morning, I am aware that a Pivot table is probably the best option for this, but basically the field listed where the data selected is a drop down and as I cannot get the Pivot Table to check the cell in order to filter different data I feel this is the best way however I cannot get the...

I already have a formula that gives me an answer however sometimes the answer is FALSE. Where the answer comes in as FALSE I want the answer to be the cell above. Thanks in advance

Greetings, I have a path that includes a date in a "YYYY MM" format i.e. c:\abc\2017 10\[abc.xlsx] Extract it is easy if it is always just before the file name, but not if it is elsewhere in the path. (at least not for me!) Any suggestions? Thanks,

Hi All, I have a PowerPivot linked to a SQL database view. I use it successfully in PowerPivot w/Excel 2016. Recently there have been additional columns added to the SQL view. I thought they would automatically appear in my PowerPivot data when I refreshed but they do not. Any suggestions? I...

I am sorry for what I am sure is a simple question, but nothing I try seems to work. I have approximately 8000 rows in an excel table formatted as follows: Date and Time 01/01/2017 0748 01/01/2017 0749 01/01/2017 0750 01/01/2017 0751 01/01/2017 0752 I need to split the date and time into two...

Alright, I have done a search and did not find for 0, for #N/A yes, but not 0. Here is the formula, very straight forward: =IFERROR(VLOOKUP(A:A,Physician!A:P,5,FALSE),"") In the results I am getting 0 instead of a "blank". Any suggestions? -T

Hi fellow Excel-freaks, I have an odd request. Usually a cell Spillover is not possible if the cell to the right is filled with anything. Does anyone know how to force a spillover even though it is filled? thanks for all suggestions BR

Hi All, I am a moderate level excel and VBA user, I want to create a billing system for one of my friends restaurant, I need suggestions from experienced excel users in the forum, how should I go about this. I mean what should be the approach for this system

I have a macro I am writing that I cannot seem to fix. I know this has been asked and I have read through some of the responses but just cant get it to work. i'm open for suggestions. Dim c For Each c In Range("B2:ZZ2").Cells If c = "" Then c.Select Exit For...

I need code that searches through all sub folders in the C drive and when it it matches to a specified file it returns the file path. Any suggestions?

Is there a simple way of retrieving the worksheet name from the code name when the code name = "Sheet" & "1", "2", "3", etc. I can do it by looping through all worksheets, but there must be an easier way. Thanks in advance for any suggestions.

Hello Guys, Just wondering if anyone out there knows of an easy way of connecting an excel sheet to an online dashboard. I have an excel sheet that gets updated several times a day with daily sales, moth to date and the targets of those figures. I'd like to be able to shows this in a nice...

Hi Everyone, I am trying to make an email automatically prefill with text and a desired email address based on a specific cell value. I am thinking I need to use a IF statement to accomplish what i am trying to do, but i am not coming up with any success, any suggestions?