expect

Hello and thank you for reading my post. This is what I need to do: I have data for three months. I need to determine what data the remaining 9 months will have based on the first three months. For example, January I had 1 credit memo. February I had 1 credit memo. March I had 3 credit memos...

I have a column of data and I want to find how many semicolons are in that column. So for example: a; b; c d; I would expect to return 3. However, for: e;f; g; h;i;j; k; I expect to return 7. I tried using: =COUNTIF(A:A,";")) but it only returned 4 for my second example...

Need some help, How to Clear the entire col expect A1 ? The column contain data & empy so i want to clear the whole column except a1 btw, i had column A column C column D column E column I column J column K need to clear

I have a cell that contains a count down to a specific time. The count down appears like this: 10d 23:18:43 Is it possible to write a formula that will convert the count down to hh:mm:ss? In the above i would expect: 263:18:43 Note that if a single day is left the cell looks as such: 1d...

Hi is there a way besides using .Formula to say sum all the B6's on the worksheets in a workbook expect for sheet1, and put the results in B6 on sheet1?

Hi, all I try to simplify my data which has an uncertain number of delimiters. sample data as follows A1 : one-two--three---four----five----- the results I expect are like this B1 : one-two-three-four-five thanks in advance

I have dates in two columns on the same spreadsheet, there are a series of records where these two date columns are identical dates so I would expect my result to be 0, but I’m getting -1. What could be causing this?

I have a problem and need some input from some clever people. I have some code which does something based on which month it is. Coloumn 1 - - - - - - - - - - - - - - -Column 2 =MONTH(TODAY())+Z2 - - - - - - -[some code based on the number in column 1, expect number 1-12] Cell Z2 I use to...

I've never used SumProduct before so I've cobbled this together after a bit of googling. The Sumproduct works great and reports what I would expect but I need to eek out more to get what I need. Here is the formula that I wanted to use..... =COUNTIFS(O:O,0,Q:Q,"No",R:R,"<" & N:N)...

I've hunted for some help in the forum, but I cannot find what I'm looking for or get it to work in Excel 2013. I think some of the threads on Index and Match are the way I should go, but I cannot get it to work. Basically I have a value on sheet1, and I want to find the first occurrence of it...

Hi, If I have a table shown below. I want to calculate the numeric rank of the item selected. For the examples below, I would expect row 1 to return something over a ranking of 3 as the selected value ended up higher than the largest option given. Where as line two's selection was in the...

Evening Everyone I have been playing with this one for a while now and unable to find a solution, I have seen many references on the board around HLookup & Match but nothing that seems to cover what I am attempting. I have a table and in Col D I have a list of dimensions in millimeters IE.230...

Looked through other posts about this and cannot make isnumber work with sumproduct =SUMPRODUCT(--(A:A>B:B)) <tbody> User 1 User 2 10 5 15 7 20 9 </tbody> I'd expect to get 3 as the answer but since it's counting the text it gives me 4, any help would be greatly appreciated