ends

The company i support has standardized IP schemes, IE the server for each site always ends in the same octet, workstation 1 for each site ends in the same and so on, what id would like to create is a sheet where a user can put in the ip for the server and it figures all the other IPS out, so say...

I’m trying to figure out a formula that does this: I want 12 columns for each month. In these columns will be calculations that adds the cost of storage based on the number of days that particular item is being stored. The first 15 days of storage is free, then .50 afterwards. How can I have...

Hi, I have a database with sets of data containing long numbers such as 1132334256. I want to pull all the data for the sets of numbers from 1132334256 to 1132334270. what would the expression be? I was thinking string between (ends with "256" and ends with "270"). I need to return all values...

Need to find row and column pivottable ends in VBA. Is this easily retrivable in VBA?

Hi all, I have been trying to find a formula that will tell me how many hours fall between two specific date/time ranges. So Range One Starts: Friday 01:00 Ends: Sunday 17:59:59 Range Two Starts: Sunday 18:00 Ends: Friday 00:59:59 The ranges can be variable and I need it to round up to a...

Hi, I am looking at a spreadsheet provided by a colleague. It appears to have restricted the column's viewable. So I can only scroll over to column AH, and then it just ends. This must be a setting, it is not like the extra columns are hidden. Does anyone know how to alter these settings...

I would like to prompt the macro to ask for a column number and then enter the following formula in the cell from row 2 onward until the last data in the column: =IF(A2="","Unique",IF(COUNTIF($A$2:$A$1000,A2)>0,"Match","Unique")). I want to populate the entire column where the data ends with the...

<tbody> Elevation A Elevation B Elevation C Elevation D 24 32 31 35 15 20 25 30 </tbody> I have two ranges of elevations (Elevation A and B and Elevation C and D) and I need a formula to determine if the two sets overlap. For example, Elevation A starts at 24 and ends at 32 and...

Hello everyone, This might be a tricky one but I'm sure someone will somehow magically solve it. So I have 5 columns lets say occupying cells in B:B, C:C, D:D, E:E, F:F with variable sizes. I want column G:G to be populated or in other words to stack up all values from these 5 columns. So the...

Hello, I created a macro to remove some cells that had a value of 0 but just realized that it actually ends up removing anything that ends in 0 as well. Anyone know how to fix this? Sub UPLOAD_REMOVE_NULL_VALUE() Sheets(3).Unprotect Password:="Genesis" Dim i As Long, lr As Long lr =...

I can't get multiple users in a new database. When I've written previous databases, I split them and made multiple front ends and had no issues. I've been working for weeks on this and can't figure it out. What I've Tried: 1. The database is split and the BE is in a separate folder from the...

=VLOOKUP([@CR],XP_table,2,XP_2) this breaks from one line in the table and the next. on line 33 of the table it returns the proper answer one line 34 it goes to #value ! now the table it is looking up ends on line 33 but that shouldn't matter as far as I can tell!

Having trouble finding formula that will look at the text within a cell and place a TRUE or FALSE -- if that text ENDS with an "X" Example: Column A holds various codes: GHRYS WJNCV ABCDX PRTYS Position 1,2 & 4 would be FALSE and 3 would be TRUE since the text string ENDS with an X I know...

Hi everyone, I have a bit of a complex problem. I have a column like the following; Training: 7, Fighting: 12, Speed: 3 I need a formula that sums together 7+12+3 automatically. Now I got a solution where i extract all the digits in that cell and sum. But that ends up giving me 7+1+2+3...

Hello Everyone! Ok, I am needing some help yet again. I am looking for a formula to do the following. F1 is a changeable field. If F1 ends in 10 (310) and G19=odd number I need G22=0. However, if F1 ends in 10 and G19=0 I need G22=1 Thank you Brian

Is there any way I can use Like to determine if a string starts with "[" and ends with "]"? Or another (better?) method than left,1 and right, 1 ?

I have a UDF called CountPeriod which is a glorified version of CountIf. The workbook is used to tally student attendance. There is one tab per month with a linear calendar at the top of the page. To the Right, I need to tally the absences and tardies for each student based on which of 3...

I'm making a workbook to track student attendance for the year. There is an identical tab for each month of the year which has a linear calendar that will change depending on the year chosen. At the end of the month I tally the number of Absences, etc for a given term. The terms begin and end...