creating/correcting array formulas to generate Ethernet switch detail charts from master Network Notes sheet

I have a workbook 17 sheets, but only 2 are the focus of this request.

1) Netw-T3-MCP1: This sheet contains all Ethernet related details for all networked control system hardware, including:

A) What switch & port a device connects to

B) IP address


D) EN2T (PLC's Ethernet card) asigned

E) PLC Node #

2) MCP3-Enet Sw Charts: This sheet is needed to build the Ethernet switch details charts for inclusion in the respective Ethernet switch drawing. the trick is having the charts filled with blanks for each port in any given switch that is not listed in the Netw-T3-MCP1 sheet. I can get the arry formulas to work for the 1st chart; however, only the first chart works. The details in the first chart work perfectly, but the successive charts only have the same info as the first chart rather than the actual switches details. I cannot seem to figure out how to edit the formula to stop this. I am indexing the switch numbers to match.

Evner: Excel

Se mere: network , ISP , router , switch , notes sheet, switch ethernet electronic module, sample network support log sheet, piano sheet music translated notes, master sheet creator, script linux backup network switch configuration, mt2a ethernet switch user guide, network switch animation, translate piano notes sheet music, create sheets excel using master sheet, switch excel vb6 app use open sheet, keyboard sheet music numerical notes, style sheet switch, music sheet numerical notes

Om arbejdsgiveren:
( 0 bedømmelser ) United States

Projekt ID: #14503618

13 freelancere byder i gennemsnit $365 på dette job


Hi, I am good at Excel and vba. I just checked the description and would be a pleasure to assist you on your project. Looking forward to discuss in the chat. -Chandra Relevant Skills and Experience Excel, formulas, vb Flere

$250 USD in 0 dage
(612 bedømmelser)

Greetings sir, i am an expert freelancer for this job and your 100% satisfaction is assured if you allow me to serve. Here is the reason. Why you should pick me? a) I am a very expert and have the same kind of ex Flere

$250 USD in 3 dage
(209 bedømmelser)

Hello, I’m an Excel expert and I would like to help you with your project. Please check my profile and contact me to discuss further details. Regards. Stay tuned, I'm is still working on this proposal.

$250 USD in 3 dage
(219 bedømmelser)

Actually it is not $250 effort (only correcting the formula involved). I can do it for $50. Relevant Skills and Experience 18 years experience in using Excel as part of daily work life. In the process, implemented lot Flere

$250 USD på 1 dag
(126 bedømmelser)

I have experience in MS Office, VBA Programming, XML, MS Work, Google Docs, SQL, Google Spreadsheet, Data Entry in Odoo, Google Document and other related applications. Relevant Skills and Experience Excel, VBA Flere

$250 USD in 3 dage
(62 bedømmelser)
$250 USD in 10 dage
(58 bedømmelser)

- Based on Netw-T3-MCP1 which has Ethernet card info, the second sheet which has (MCP3-Enet Sw Charts) the chart info details, can get the info for all the Netw-t3-MCP1. - Will get it processed using macros so that wh Flere

$250 USD in 2 dage
(37 bedømmelser)
$250 USD på 1 dag
(20 bedømmelser)

With 9 plus years of experience, I am confident that I can fulfill requirements of project very efficiently in a very reasonable time. I am looking forward to discuss with you about this project. Relevant Skills and E Flere

$250 USD på 1 dag
(6 bedømmelser)

hey there, i am full stack developer and from what i understand you need to have some algorithm. lets discuss more details in chat. regards Relevant Skills and Experience full stack development Proposed Milestones $5 Flere

$500 USD in 10 dage
(1 bedømmelse)
$555 USD in 10 dage
(0 bedømmelser)

I am a Cisco expert with an experience up to 12 years as a senior network engineer and as a part-time Cisco instructor,moreover I have a master degree in communication and electronics engineering. Relevant Skills an Flere

$555 USD in 0 dage
(0 bedømmelser)

Though I am new here but my team has 7 years of experience into MS Excel. Can very well execute this Project

$888 USD in 0 dage
(0 bedømmelser)