point

Can someone please help me? I have over 43000 rows of data in an ExcelTable. I need an efficient forumla that determines streaks of zeros & ones and uses Excel Table nomenclature. In this sample, there are two pieces of data (i.e., wtn high and wtn low) and four corresponding columns (in...

Hi All I hope someone can help I have a column with lots of data in it (I have attached a small portion in the workbook) I need to rank every six entries going down the column. I have googled and found the + countif option to break the ties but I cant seem to get it to work? I hope someone...

Hello! I´m using vba code to create a chart and customize/emphasize a specific data point marker. But when I do that, the legend changes from showing a single label for my unique series of data to showing multiple labels, one for each legend entry corresponding to each data point (x-value) of...

Hi could anyone help me with this i'm going number blind! https://1drv.ms/x/s!Aszg_mMOoSFEgSM203OyZbldchOt?e=LLq6Ur When I select TU1 in C7 I get the correct results from the table $J$14:$O$20, but when I select TU2 from the dropdown in C7 I'm not getting the results I need? Can someone...

Hello All, I'm looking for a way to conditional format each segment of a line chart. Basically, if the segment is positive (from a lower point to a higher point) I want to the segment to be green. If the segment is negative ( higher point to a lower point) I want to the segment to be red. Any...

Good morning all, After some help please, I have a pivot table that plots a value in a cell of when our stock will last to(columns "D" onward are grouped as months/quarters/years. What I would like to do, which I have no idea how to, is highlight each row up to the point the value is...

How can I record # of times a stock reaches a certain number throughout the day? Currently I only have a function for when it is at that number it returns 1 and if not a 0. i need a running count. Basically I am looking to record the success of a tick fade play. When the $TICK reaches +1000...

I have acciden Unit measure of +/- .25. If my result is .25 my %score point is 100, if my result point is decreasing my %scorepoint should increase too. Can someone help me with the formula thanks

I have a db filed with numbers stored as strings. I need to convert them to 9 characters but some had their leading zeroes trimmed off at some point. So, 012345678 became 12345678. I would normally do Text(stringHere,"000000000") to convert this in Excel. Is there an equivalent function in...

Given the following with expected results: <tbody> Point Pm10 Rank 1 .12 2 2 .13 1 3 .12 3 4 .12 4 1 .12 3 2 .15 1 3 .13 2 4 .11 4 </tbody>

Hello Team Here is the example <tbody> # 1 1 CREATE POINT 744STEAM:FA0032.PNT 1 PUT POINT 744STEAM:FA0032.PNT TYPE FLOAT DESC = "4 RECOVERY MCR" AUDITUPD = NO COLLECTOR = srhc03 # 2 1 CREATE POINT 735WLCLF01:FY0046B.RO01 1 PUT POINT...

got this frmula here and it does work as long as my numbers are smaller than.10000 =LEFT(H29,3)&"."&MID(H29,4,1) i need to have the decimal point 1 digit from the right. at ALL times HELP

Hi there, I have a range (EF60:IV60) and I need to return the last value which is not blank or 0 I'm having a brain freeze moment... I've tried: =IFERROR(0,LOOKUP(2,1/(EF60:IV60<>""),EF60:IV60)) but it's not having it.... If you can point me in the right direction, I'd be most grateful Thanks

Hi Is it possible to do the following in pivot table? Do running total % of row total based on the values of the running total in point 1 <tbody> A B Total 1 2 3 3 3 6 4 1 5 </tbody> Running total <tbody> A B Total 1 2 3 4 5 9 8 6 14 </tbody> % of row total <tbody> A B...

Can someone please try this and see if you get the same problem? In a new workbook, put the number 1 into cell A1. Then add a Data Validation rule, stating it must be a whole number greater than 0. Now in the VB Editor, put this is Sheet1: Option Explicit Private Sub...

hello I'm writing a macro for: 1 add something in the object 2 forward the mail, 3delete it 4 open the next one. 5 open the attchment stop macro I was able to write the first 5 point but I'm getting crazy for the last two, which is open the mail after and attachment as well. could you help...

Private Sub TextBox1_KeyPress(ByVal KeyAscii As MSForms.ReturnInteger) With TextBox1 If InStr(.Text, ".") > 0 Then If Len(Split(.Text, ".")(1)) = 2 Then KeyAscii = 0 End If Select Case KeyAscii Case Asc("0") To Asc("9") Case...

Hi, I am trying to work out who in my data is eligible for a pay increment. I have a 2 column lookup table $A$2:$B$28 that shows Grade in Column A and Scale Point Ceiling in Column B e.g. Column A GRADE Column B SCALE POINT CEILING Administrator...

Hi there, hoping someone can help me sort out a poorly formatted data-set which I've inherited and need to clean up to create some reports. In short, the data-set extends out from column A to column A0, and has 435 rows. Each row shows a unique 'case number' and then against each case number...

Hello, Here is my problem. I need a formula solution for this. NO VBA. I have a single column (A:A) large (around 70000 rows, distinct) data. From that data, I need to extract some of the rows to another sheet based upon the starting and ending cell values. Here is the example for problem. In...