How JustAnswer Works:

  • Ask an Expert
    Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional Answer
    Via email, text message, or notification as you wait on our site.
    Ask follow up questions if you need to.
  • 100% Satisfaction Guarantee
    Rate the answer you receive.

Ask John D Your Own Question

John D
John D, Engineering Consultant
Category: Networking
Satisfied Customers: 9658
Experience:  Bachelor of Science - Engineering Consultant
53785
Type Your Networking Question Here...
John D is online now
A new question is answered every 9 seconds

John D answered my question before-maybe he can answer these

Customer Question

John D answered my question before-maybe he can answer these :
-I am working on a big spreadsheet, actually 500 columns. Is there a way of expanding the spreadsheet beyond IV...A goes to Z and AA goes to AZ but IA only goes to IV...I need the spreadsheet to get up to say MZ....
-when I link the worksheets...I have a list of historic prices..the names of the stocks are at the top of the columns..IBM CSCO etc and the dates are in my rows...(I tried putting the names in the rows and the dates in the columns but still ran out of space because I have a year's worth of dates)..anyway I want to compare the historic dates with the current stock prices in order to rank the best to worst performing stocks at a given date...so in my One Year worksheet I have a column that takes the prices from the historic worksheet so my link is for instance =Fixed1!HV2 for a date of 11/17/09; the next day I could do =Fixed1!HV3 and so forth, that way I can compare the present price with the price at a specific day and get a % plus or minus; the objective is that I can then do a sort on the Performance column and get the best to worst..so two subsidiary questions:
a)-in my One Year worksheet I have had to copy the same formula over and over again manually...i.e.=Fixed1!A2;then =Fixed1!B2 all the way out to =Fixed1!IV2...is there some way I can automate this process? I tried the Concatenate function but that doesn't work in the case of a link..
b)-if I can't get all the historic data in one worksheet (so I used two worksheets Fixed1 and Fixed2) and I change the dates (for instance to do a One Month Performance sort) the prices will change up to IV if I highlight up to IV but beyond Excel goes into a tailspin and I have to Cntrl+Alt+Delete.
On smaller spreadsheets I can highlight the column and go Cntrl+F=Find and Replace, Find the current date say all the 2s and put say 241 in Replace for one month ago and all the prices change, then do my sort...

I'd send you the spreadsheet but it updates on Thomson Reuters so without Thomson all you'd get is #NA..I used to have Bloomberg that works much better for this kind of thing. I've also used a VBA macro that someone gave me that works on Yahoo but Yahoo can still only take 100 odd fields at one time so I need 5 spreadsheets to do the job. My current workplace uses Thomson that can handle the data but Excel is lacking....can you give me all or any part of the answers to my questions?
Submitted: 3 years ago.
Category: Networking
Expert:  John D replied 3 years ago.

Welcome back!

 

Unfortunately Excel versions 2003 and earlier have a maximum limit of 256 columns (i.e. up to column IV). But in the newer versions the number of columns has been substantially enhanced, You can now have 16384 columns (up to column XFD)

 

So I suggest that you upgrade to Excel 2007 or 2010.

 

However as workaround you may able to utilize your rows and use your data vertically by transposing it. If you need help in this regard send me your file and I will try to set it up for you

 

Hope this helps

 

 

John D, Engineering Consultant
Category: Networking
Satisfied Customers: 9658
Experience: Bachelor of Science - Engineering Consultant
John D and 7 other Networking Specialists are ready to help you
Customer: replied 3 years ago.
Thanks, XXXXX XXXXX have Windows 7 at home but my workplace is not about to upgrade from Windows 2003 and I need it to work at work because the data is at the workplace..Can you asnwer my other questions...>
How can I send you the file?.
Expert:  John D replied 3 years ago.

Sure, go to www.wikisend.com and upload the file there (no need to sign up). You will then get a page that has the File ID and Download Link. Copy either the File ID or the Download Link and come back here and paste it in your reply.

 

If the file has sensitive information you can either replace the sensitive data with dummy values, or let me know before you upload it.

 

JustAnswer in the News:

 
 
 
Ask-a-doc Web sites: If you've got a quick question, you can try to get an answer from sites that say they have various specialists on hand to give quick answers... Justanswer.com.
JustAnswer.com...has seen a spike since October in legal questions from readers about layoffs, unemployment and severance.
Web sites like justanswer.com/legal
...leave nothing to chance.
Traffic on JustAnswer rose 14 percent...and had nearly 400,000 page views in 30 days...inquiries related to stress, high blood pressure, drinking and heart pain jumped 33 percent.
Tory Johnson, GMA Workplace Contributor, discusses work-from-home jobs, such as JustAnswer in which verified Experts answer people’s questions.
I will tell you that...the things you have to go through to be an Expert are quite rigorous.
 
 
 

What Customers are Saying:

 
 
 
  • I am very happy with my very fast response. Eric is very knowledgeable in the subject area. Thank you! RP Austin, TX
< Last | Next >
  • I am very happy with my very fast response. Eric is very knowledgeable in the subject area. Thank you! RP Austin, TX
  • My Expert answered my question promptly and he resolved the issue totally. This is a great service. I am so glad I found it I will definitely use the service again if needed. One Happy Customer New York
  • Wonderful service, prompt, efficient, and accurate. Couldn't have asked for more. I cannot thank you enough for your help. Mary C. Freshfield, Liverpool, UK
  • This expert is wonderful. They truly know what they are talking about, and they actually care about you. They really helped put my nerves at ease. Thank you so much!!!! Alex Los Angeles, CA
  • Thank you for all your help. It is nice to know that this service is here for people like myself, who need answers fast and are not sure who to consult. GP Hesperia, CA
  • I couldn't be more satisfied! This is the site I will always come to when I need a second opinion. Justin Kernersville, NC
  • Just let me say that this encounter has been entirely professional and most helpful. I liked that I could ask additional questions and get answered in a very short turn around. Esther Woodstock, NY
 
 
 

Meet The Experts:

 
 
 
  • James

    Sr. Network Administrator

    Satisfied Customers:

    1711
    Highly experienced with wireless networks and wireless equipment, LAN and networking protocols
< Last | Next >
  • http://ww2.justanswer.com/uploads/BA/barrenrock/2011-10-19_215925_JamesJAFinal.64x64.jpg James's Avatar

    James

    Sr. Network Administrator

    Satisfied Customers:

    1711
    Highly experienced with wireless networks and wireless equipment, LAN and networking protocols
  • http://ww2.justanswer.com/uploads/Claws224/2009-07-07_063935_Dork_Portrait.JPG Claws224's Avatar

    Claws224

    IEEE Network Engineer

    Satisfied Customers:

    1256
    IEEE, Microsoft
  • http://ww2.justanswer.com/uploads/KN/knelly74/2011-4-14_215651_kevin.64x64.jpg Kevin's Avatar

    Kevin

    LAN/WAN Specialist

    Satisfied Customers:

    1165
    Certified MCSA and MCP Network Administrator with over 20 years of PC experience.
  • http://ww2.justanswer.com/uploads/tealnet/2009-09-26_000218_headshot_64.jpg Eric K.'s Avatar

    Eric K.

    Network Administrator

    Satisfied Customers:

    510
    13 years of desktop, server and network support experience
  • http://ww2.justanswer.com/uploads/CL/clagesolutions/2012-6-27_145545_20120608Geoff.64x64.jpg Mr. Clark's Avatar

    Mr. Clark

    Network Engineer

    Satisfied Customers:

    510
    Computer Business Owner / Former DoD Network Specialist
  • http://ww2.justanswer.com/uploads/MA/matthewpj73/2012-1-20_18729_TWO.64x64.jpg Matthew J's Avatar

    Matthew J

    Computer Support Specialist

    Satisfied Customers:

    397
    12+ yrs computer diagnosis/repair, network infrastructure install and support, IT Administration
  • http://ww2.justanswer.com/uploads/SE/Seashore2011/2011-12-6_33418_111205223015.64x64.jpg Chris L.'s Avatar

    Chris L.

    Support Specialist

    Satisfied Customers:

    384
    Certified Networking expert with over 10 years experience.
 
 
 

Related Networking Questions