point

Hello! Can you tell me please how to insert to cells the below characters/format, preferably with a formula as I want to blend them with other text and formulas. • Dfgdfg o Fdgdfgdfg  Fgdfgdfg if the above don't display correctly, you can get them from MSWord where it is basically the first...

Hi, I have an interesting case with line charts. There are 4 tables and 4 line charts in linked file. 2 of the charts show 0 point on x axis and the other 2 dont. I can set the maximum amount of x axis to be zero, but it will not work if numbers are positive. I know there is a logic behind...

Dear All, I currently have a spreadsheet that will be copied and pasted into a power point presentation each time it is used. Is there a way to capture a screen print of a given cell range (A1:AE132) or what is currently on screen (Excluding the top ribbon, Formula bar and headings) using a VBA...

I’m trying to track cohort survival through a training program. One issue I am struggling with is the impact of the cohort size on how that displays in the data. The course is quite demanding so there are always going to be losses. for example: cohort 1 has 100 students and at a point, 1...

i was to place a yes in a cell if K2's text has and *RD* in it at any point. i had the following but it returns a false. =if(K2="*rd*", "yes", "No")

Hi, I have a Worksheet with multiple Tables, how can I find the Table Name of the Table I'm currently in? Everything seems to point to ListObject(1) but I don't know which ListObject Number it is. Any help appreciated :)

Hi I would like a formula that allocates 10 point to highest bidder, the second bidder get proportion of the 10 point as distance from the highest bidder, so same from bidder 3 etc. Hope the above makes sense Any help would be much appreciated Thank you

Good Evening! I am struggling with a formula, hoping someone can point me in the right direction. In a cell I have a text string that says "#15 of 214 H.." I need to extract the two numbers into their own cells. In this example 15 and 214 respectively. However, the numbers could be as...

I have a pivot table where my rows are client names an the columns are dates. Is there a way that I can use the getpivotdata function to identify a reference starting point and then sum the prior twelve dates/columns. If there aren't 12 prior dates/column, it would just return zero? I am...

Hello, I just finished doing assessments for my 37 Athletes and now for my assessment report my team leader wants me to make each criteria worth the same amount of points as the percentage it represents. For example Jumps are worth 20% and I have 22 boys and 15 girls so I want to allocate a...

Hi - Sorry if breaking protocol here, but I posted to an old post this morning which probably doesn't have any visibility at this point. I placed the URL below and would appreciate if someone could review and reply to the inquiry. Thanks in advance...

Hello, I am currently trying to develop an attendance tracker in Excel that will minus 1 point if 30 days of perfect attendance is achieved. I have been able to write a formula that will deduct the points if that time frame is met but, the problem is that when they get another point for absence...

I have a fictive criminal register and would like to count number of points on the driver's license. I have a COUNTIFS that looks up the social security number from H3. D has the social security number and V has "1 point", "2 points" or "Suspension" (3 points yields suspension). Here I have...

Hi all, I have 2 criteria, and based on which one is rtue I would like the colour of a line on the line graph to change. I am doing this for points in a tennis match to show the momentum changes. If Roger Federer wins the point the line graph goes up by 1, is Novak Djokovic wins a point the...

Hi, I have the below data that I want to sum, but only to a certain point: <tbody> Number of cats 7 8 10 11 12 Cumulative cats 7 15 25 8 0 Cap on the number of cats 33 </tbody> I have information on the number of cats in each house, as can be seen it is 7 in...

How to connect Specific Point in Scattered Graph. <tbody> X Y 1 10 5 15 6 20 6 17 6 15 10 30 </tbody> Say i want to draw a line to join point (1,10) to (5,15) to (6,17 ) Another line (6,15) to (10,30)??

Hi Yesterday, I inserted a bar chart. I right clicked on any bar in that char and then clicked on "Format Data Series" then Click on Fill icon, but could not find []Vary colors by point!! I am not able to reproduce that issue again! My question do you know under which circumstance that option...

I had a time coming up with a concise title... but hopefully this will explain it better. I have a line chart with values on the vertical and yearly quarters along the horizontal. The yearly quarters are labelled 0.25, 0.5, 0.75, 1.0, 1.25... etc. As there area lot of quarters I have the...

Using Windows 10 and Access 2010 I would like to have the 'Surname' field, in table / datasheet, to be in Bold but I can't find how to do this. I have the field set as 'text' Can anyone point me in the right direction, please? Any help and/or advice would be very much welcomed. Many thanks

Hi there, I have a workbook where, when any cell is selected, it goes into "edit mode" - ie the cursor flashes at the end of the cell content I have a button in a "mini menu" where I want a 'fake' bullet point 'ChrW(&H25CF)' to be inserted where the cursor is flashing. I know that this is...