tia

Hi all as i want to ignore the word "undelivered" when searching for the most common word what i have is - =MODE(IF(A6:A1000<>unknown,A6:A1000)) (array formula) it says #Name as a result TIA

Is there an easy way to create a vba button to cancel all current slicer selections? TIA

Hello, I am writing a program in java and need to add macros to an excel workbook. Is there a way to add them through command line using a VB script? TIA!

I need to remove the highlighted part of the formula but when i do it says error so how what else do i need to remove ? =IFERROR(INDEX('Shirt Database'!H:H,SMALL(INDEX(('Shirt Database'!$A$2:$A$59998=$A$1)*ROW('Shirt Database'!$j$2:$j$59998),0),COUNTIF('Shirt...

Hi, can anyone please explain what the two "diamonds" are on rows in columns D & J, how they were created and how to remove them? Asking for a friend so don't know what they've done to create them? Many TIA

I am switching to Win 10. Is there any reason not to go to Access 2010 as well? tia Jack

Win 7 Access 2007 Rather than creating a menu is it possible to import a menu from another .mdb? tia Jack

How would I convert a number and sign to a number? For example how to convert 20- to 19.75 and 20+ to 20.25. TIA

In design mode for a form I sometimes will not be able to see properties for text box or form etc. To enable the property sheet in the immediate window I enter CommandBars("Property Sheet").Enabled = True Is there any way to always have the property sheet enabled? Or to do it a start up time...

Hi, I am trying to create a formula that will calculate the number of Wednesdays in a month and multiply it by 28.46. How would I do that? TIA Edited to add: My columns are months: <colgroup><col span="2"><col span="2"><col span="2"><col><col span="5"></colgroup><tbody> JAN FEB MAR...

Hi, Anyone who knows how to bypass the 255 Characters rule in VBA? I have to put something that has a formula containing 1599 characters. Unfortunately, I don't know how to incorporate the formula in vba. TIA

Hello guys, i would like to ask if is it possible to filter a column that contains a specific data in macro. For example i would like to filter out data that contains 9000 or 5000. But the data in the column for example is 500012312. How would i do it? TIA

Hi, I want to sum the cells in Column A in condition that the date in Column B is later than 1/1/2016. I need it for VBA because I'm running this on 100 sheets. TIA Nati

Hi! I'm trying to figure out how to do the formula for: 893.30 (A1) is a negative percentage of 1393.30 (B1). I've figured out that: =(B1/A1)-1 = 0.559723. But I'm looking for the opposite...that A1 = -.44027 (a 44% loss of the original value) and I just don't know how to make Excel give me...

ive a list of names in c5:c500 which appear numerous times. what i am trying to do is to get the unique value only once so if paddy appears 5 times in coulum "A" then it will appear once once in column "x". X5:x500 is where i want the unique values to appear i do not want to use any other...

Is it possible to convert an application from Access 2003 to Access 2007 not creating an .accdb? tia Jack

I would appreciate any thoughts regarding a user defined report generator. Would prefer to buy, or get one free. tia Jack

Hi All, Can someone help an idiot with the combined formula, :) TIA

Scenario: <tbody> B2:B5 39 48 53 67 68 </tbody> L53:P53 12 14 20 39 40 Why wouldn't this formula give back a "TRUE" value? I did do the Ctrl-Shift-Enter for the formula. =INDEX(B2:F5,MATCH(B2:B5,L53:P53,0),"TRUE","FALSE") TIA