| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
PING within Excel Cell
I have a column of workstation ID's, around 4000 entries. I want the next
column to give me a PING result (simply Success or Fail will do). Is this possible? I already have a tool to do multiple ping's that I can export and paste in, but I want it to be live in Excel. Ideally I would set the sheet to manual calculation, and it would only update the result when I hit F9 to calculate, or it would only update results when I hit a Macro or something, otherwise I know it would probably be slow! Rgds Steve |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
PING within Excel Cell
Hi Steve
You can try this formula =IF(ISERROR(VLOOKUP(B2,A2:A84,1,0)),"Fail","Succes s") hope this would help you. Regards Vikky Steve wrote: I have a column of workstation ID's, around 4000 entries. I want the next column to give me a PING result (simply Success or Fail will do). Is this possible? I already have a tool to do multiple ping's that I can export and paste in, but I want it to be live in Excel. Ideally I would set the sheet to manual calculation, and it would only update the result when I hit F9 to calculate, or it would only update results when I hit a Macro or something, otherwise I know it would probably be slow! Rgds Steve |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| missing cell borders in Excel | Excel Discussion (Misc queries) | |||
| Help with this conditional IF statement | Excel Discussion (Misc queries) | |||
| resetting last cell | Excel Discussion (Misc queries) | |||
| Copy cell format to cell on another worksht and update automatical | Excel Worksheet Functions | |||
| Paste rows of numbers from Word into single Excel cell | Excel Discussion (Misc queries) | |||
Linear Mode
