assist

Afternoon Can someone assist with the correct syntax for the below countif :confused: cell(1,12).formula ="=countif(G1:G100),"<=10000")

I receive a daily email with a PDF report in it and I want to convert it to Excel so that I can do some sorting etc. as it has lots of info on it that is not used. Would someone be kind enough to assist with some code to be able to do this in a macro that I can add to my sheet The pdf will be...

I have concatenated info from two other columns, in cell A9 and Im having trouble figuring out the VBA to autofill dynamically until the corresponding column B is at its end, which varies. Can anyone assist? This is getting inserted into a larger macro I have.

I have a table i would like to sum the total for each month of the year, however, I'm not sure why is not calculating the sum. Can someone assist. The array formula I'm using... =SUMPRODUCT(MONTH(D16:D45)=T3,YEAR(D16:D45)=U2,P16:P45) Thank you

Hello, I have tried with no success yet to add an attachment to my post for clarification. Can someone please assist? Thank you

I have a range name called Unit_Sales in Col D on a Pivot Table and refers to cell =Summary!D24 I would like this to change dynamically as the Pivot table range changes It would be appreciated if someone could assist me

Hello, I have a file path in cell D11 R:\ABC\AIS\GREM\DATA_NSO\Data\Dashboard Reports\Region1\ and I would like to return the value of Region1. Can someone please assist?

All~ I am looking to write a formula that takes the data from u2:dr2, find the first reference to the number 70, search right to left, and then returns the corresponding date in u1:dr1. I have tried all kinds of things and just can't seem to get it correct. Do any of your brilliant minds have...

I need a formula that will find the highest numerical value in the range B2:B5000 but only if the following criteria is met; The value in column C must be the same as cell A3 and the value in column B must be the same as cell A1. Can anyone assist me please?

Hi, I just recently purchased called " Power Excel with Mr Excel" (edition 2017). On the back of the book, I am referred to a site "https://www.mrexcel.cl/2017/powerfiles"...th site in question doesn't seem to exist ? Can you assist me ? Thanks

I have names in Col A that is the same as the names in the address book in Microsoft Outtlook I need a macro that will extract the email address/es in Col B based on the names in Col A It would be appreciated if someone could assist me

I have description in Col A. I need a sumif formula or another formula to sum the data where I have summarised the descriptions into categories See sample data below It would be appreciated if someone could assist me Book1AB1COS Shirts Used15952COS Tracking Used25843O/all PRF...

I posted this problem in Mr. Excell a couple weeks ago: [ “I came up with a formula attempting to confirm (true or false) if 3 logic conditions are met. I’m attempting to determine if any person being tracked on my spreadsheet entered the facility and was physically here between the...

Hello All, I am new to the world of using VBA and I am looking to get some help in writing a code that follows a set of conditions and applied it to a data base. I would really appreciate it if someone could assist me learning how to write the task rather than a straight up answer example...

Hi all, I have a subscript out of range error, but i cannot find the reason why. Whatever i do or change, it still comes back. Debug shows me range selection as an error. Can anyone assist me? char1 = "'" char2 = "/" char3 = "-" char4 = "," char5 = "." char6 = "ß" Set rng1 =...

Hello, I have a spreadsheet that we using for inventory. To assist the counters I created buttons/macros to assist them with filtering and searching. There are a number of cells that I want to protect but when I do the buttons/macros do not work either. Does anyone know how to get around...

A coworker of mine made some changes to a workbook and saved those changes. She is now trying to recover the initial workbook (before she made the new changes and saved it). Can someone assist me with how to recover the old file. Thanks

I am trying to do a similar function to a vlookup but the data is not a value. For example, i am looking for a ID of a customer that is all letters and want to return column 5, can someone assist w/ that function i should be using?

I need to have a list "flattened" <technical term? Part IDS is column B contains different suppliers for parts in column A. Multiple suppliers need to be spread out into individual columns so there is a single part number in column A. How it looks <tbody> ID VENDOR_ID PART_NO COST 01011 68...

Happy New Year Everyone, I am trying to use an IF Statement here; however keep getting Syntax Error. Appreciate if anyone could kindly assist. Thank you =IF((K7)>=60,(K7)<80),0.02, IF(AND((K7)>=80,(K7)<100),0.035, IF(AND((K7)>=100,(K7)>=120),0.0425,0.05))) If the result is >=60%, then it...