idea

HI I have a pivot table with a slicer for city. I want to be able to set and block the slicer to specific city depending on the <code style='margin: 0px; padding: 0px; border: 0px; font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; line-height: inherit...

Hi all, Im standing in front of the task (see picture attached) and I cannot to figure it out . Does anybody has idea how to achieve desired result based on the criterias defined? The result should be done by fromula, not by pivot or vba. If possible, do not use any formula in data table... Im...

Hello - Excel is telling me that I have an error with this formula. Does anyone have an idea of what it might be, and why? Thank you very much...

I am recording a simple macro: going from one spreadsheet to another. When I do, VBA records the step as ("Name of spreadsheet").ErrorString, when it should be, Sheets("Name of spreadsheet").Select Any idea why this is happening? Thank you so much!!

I have a pivot that has a field with very long text. The text is all there in the pivot however when I do a VLOOKUP against the Pivot, that field's data keeps getting cut off. Any idea how I fix this so that the full text shows up?

Hi I am getting the above message when I try to run the code below. Any idea why please? Thanks you. Sub test() Workbooks("test1").Worksheets("sheet1").Range("a1:c10") = 1 End Sub

my table sorts based on date and I want to insert a blank line at the end of the work week so that I can get a clear idea of what needs to be done. Is there a VBA code I and use that will accomplish this?

Dear community, I've been struggling for two weeks now and i can't figure it out. countless attempts of trying brought me here so I hope some of you experts are able, and willingly to help me out. This is what I'm looking for: Whenever the IP addres is changes, i need the webquery output...

when i thinking use if else statement to finish this but it can't, because base on Western Electric rules 2 it must return both value.so i have no idea using what condition to process this code. *example is Two out of three consecutive points fall beyond the 2σ-limit then it will return this...

Hi I wrote a code to create a text function that would add "ing" to whatever the user pass as an argument. It did not work. Any idea please. Thank you. Public Function foo2(text1 As String) foo2 = text1 & ing End Function

Hi, I have 2 column table (name, subname). I would like to look up whether each subname for a given name is also used as a name and has a subname. If yes, add this subname behind original subname and repeat for the new subname unless no subname is left, then next row. Any idea? I can...

Hi Any idea as to how this can re-written so it can be simpler and calculate faster...

For some reason when I send work to my boss or she opens and saves a file of mine or anyone I believe. All the colors change. she does not know why, and I have never seen anything like it. Does anyone have an idea of why this might happen. I have checked the color index# and that does not change.

Good Morning, It may be easier to explian in a diagram below what I am trying to acheive. Any help would be much appreciated. <tbody> Ideas Date Created Revised Date Idea Rating Idea 101 Low 20/01/18 - Cell reads whether text in Idea 101 Low, is Low, Medium or High and dispalys that...

Hi I want to create my own if() function so I did the following which did not work. Any idea would be very much appreciated Function myif(x) myif = application.IF(x>80,"a",IF(x>60,"b",IF(x>50,"c","f"))) End Function

Hi I have nested if() i.e. =if(cond1, "a", if(cond2,"b",if(cond3,"c",f))) I want to know if I can name that function to for example XYZ and use that name to pass it to another function instead of passing the whole function. Similar idea of naming a range A1:A20 as ABC and then use it as...

Hi dear forum members. Consider the following: Const MyConst = "A" & "B" & "C" & "D" Sub Test() Dim Myarray() As Variant Myarray = Array(MyConst) Debug.Print Myarray(0); Myarray(1); Myarray(2); Myarray(3) End Sub Of course, the above code won't work but you get the idea ...

I have a column with both text and numeric values due to some data import format. I am trying to insert a single cell if it contains a number. I am using the below code which works at only shifting the cells with numbers in them, however it is inconsistent with the number of cells it inserts...

Hi If I click on Share Worksheet then Protect workbook/sheet will be grayed out. so I should first pportoct workbook/sheet firs then share. What is the idea behind this sequence.? Thank you very much

I have a freetext entry textbox (tried a cell) that users can enter details however i can seem to get it to bring up scroll bars. Any idea how I do this? Thanks