expected

Hi, Please find here below the link of sample workbook. Where i am trying to fetch the data with the help of Sumproduct formula but it is giving the correct output. I have mentioned the Expected results in Slip tab. Any help would highly be appreciated. Thank you in advance. Regards...

Hey everyone. I am working on a worksheet that will have some basic columns, nothing set in stone yet, but essentially A8 would be an employee's name, B8 would be their expected return time, and other random data that is calculated. Let's say it is John Doe and he is expected to be back by...

Hello Folks, I want to delete few words in A2 cell of all the sheets in my WB. Please go through the 4 strings and their expected results. I want to keep the last numeric value of the string and if the string contains Alphabet as last word it should keep both numeric value and alphabet also.The...

Hello all! I have a question regarding VLOOKUp. I have a list of IDs and Values. In a set of data I need to get the IDs with only ONE occurrence. Here is the Sample Look up table ID VALUE 1 a 2 b 2 c 4 d 4 e 5 f...

I don't do much with VB and need some help to count/tally up the number of instances of a given value. Data is sorted by the value so all results are together just need a ongoing count till value changes or cell is blank Value, Expected Result 23589, 1 23589, 2 23589, 3 23599, 1 23599, 2

Hello, I've extended my sheet range formatting to a combobox column list indexes. All work as expected, except for column 4 where a list separator or ) is expected. I've futzed with this on several occasions and I'm just not getting it. Any ideas greatly appreciated. Option Explicit Sub...

I have a file with only four values for x & y when I make a chart and insert the trendline form +-x³ +- x²+- x +- cte the backsolving of the trendline for the values of x doesn't result in the expected value for y any help is greatly appreciated can give the file with the chart if needed...

Hi Everyone, I have following line for sales order monthly forecast for 2018. Months on A1 to L1 and figures on A2 and L2 <colgroup><col style="mso-width-source:userset;mso-width-alt:2016; width:43pt" width="57" span="12"> </colgroup><tbody> JAN FEB MAR APR MAY JUN...

I have a chart that is populated, collecting data from each month of 2017 and I'd like to reuse this for 2018, but need to modify to cut down on the work. <tbody> App Month <tbody> Expected Uptime </tbody> Downtime Total Uptime x App1 Jan 737:15:00 10:00:00 727:15:00 x App2 Jan...

I have a Pivot Table that is connected to an OLAP source. Is there anyway to change the filter to only display the "Expected" row for 2018? I am creating PivotCharts from this table, and I do not need the Expected column to be displayed multiple times.

but, when entered in to a cell the value does not appear, but instead there is a zero. Isnumber confirms it configured as such. Can you help?

Currently, I am trying to count all the fields that have a date (some have links inserted to them and some don't) and I am getting an error message. My formula is: =SUMPRODUCT(--(MOD(COLUMN(H12:FB)-COLUMN(H12),7)=0),--(LEN(H12:FB)>0),ISTEXT(H12:FB)+ISNUMBER(H12:FB)) the error it's giving me...

Hi all, Using the very simplified and cut down (and I don't run a fruit stall!!!) version of a purchasing sheet that I am trying to improve for someone, I was wondering if I could have some advice please... It's very simple, they use this sheet to decide what stock to buy. Opening stock...

Hi I am trying to write a formula in a range. I am suing the code below to define my range: range("b" & m + n + 11&":k" &m+n+11) m, n are defined as integers VBA doesn't seem to like it. It highlights ":k" and comes back with the message: "Compile error: Expected: list separator or )" Can...

Hello Everyone, I am using excel table for mail merge, everything was working fine untill once i got the error stating "External table is not in the expected format". And now everything is mess. Kindly help me in this matter. Thanks.

Hello ! I am trying to make a counting for unique value on the same date. I've seen several formulas here and it's too complex for me to understand :(. Staff record ( Sheet 1 ) <tbody> A B C D 1 Date Staff Dep Quantity Wa Quantity 2 12/1/2017 Alex Expected value 1 Expected Value 1 3...

Hi All The link below shows 2 screenshots of the same formula with 1 working as expected and not the other. The top screen shot with the column circled in green shows the results of the column before it, condensed to the first 3 rows. The bottom screen shot with the column circled in red using...

Greetings, What are the limitations for establishing ranges using "For Each" loops? I am receiving an "Expected In" error on the line below. I am going to be stepping up the sheet but would like the last test integer value to occur simultaneous to the second row value. How is best to do...

Greetings, I am receiving an "expected: list separator or )" on the following line. C = PA.ws.Range(Cells(D, "A"): Cells(G, "A")).Rows.Count I am trying to set an integer variable for a range of cells defined by other integer variables. Where is the error?

Hi, I have a problem. I have around 300 Rows of data with uneven cells in different columns as below <tbody> A B D E 1 x1 Expected Output 1 x1 x2 x2 2 y1 2 y1 y2 y3 y2 y3 3 z1 3 z1 4 u1 4 u1 u2 u3 u4 u5 u2 u3 u4 u5 </tbody> Columns A...