1. Computer problem? Tech Support Guy is completely free -- paid for by advertisers and donations. Click here to join today! If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members.

Auto-Table

Discussion in 'Business Applications' started by ChhabiAcharya, Aug 4, 2017.

Thread Status:
Not open for further replies.
Advertisement
  1. ChhabiAcharya

    ChhabiAcharya Thread Starter

    Joined:
    Aug 4, 2017
    Messages:
    3
    Namaste!
    I wonder if we can create table in excel entering:
    No. of cells to be filled up and variables (with their repetition times) to fill with.


    Thank you!
     
  2. Keebellah

    Keebellah Trusted Advisor

    Joined:
    Mar 27, 2008
    Messages:
    6,553
    First Name:
    Hans
    Namste! to you too.
    Welkom to the forum.
    Could you please elaborate? your question is unclear (to me)
     
    ChhabiAcharya likes this.
  3. ChhabiAcharya

    ChhabiAcharya Thread Starter

    Joined:
    Aug 4, 2017
    Messages:
    3
    I'm glad that you've heard me. Here, I've attatched an image of what I mean: the condition resulting into a table.

    I think I'm little bit demanding, sorry.
     

    Attached Files:

  4. draceplace

    draceplace

    Joined:
    Jun 8, 2001
    Messages:
    2,583
    Could you explain how this might relate to a Business Application? Looks like a homework assignment...The values seem to be populated randomly?
     
    ChhabiAcharya likes this.
  5. Keebellah

    Keebellah Trusted Advisor

    Joined:
    Mar 27, 2008
    Messages:
    6,553
    First Name:
    Hans
    True, :)
     
    ChhabiAcharya likes this.
  6. draceplace

    draceplace

    Joined:
    Jun 8, 2001
    Messages:
    2,583
    The code for a Sudoku generator would do this. Here's video tutorial <-link
    Not exactly the answer but theory is similar. There are several approaches to take.
     
    ChhabiAcharya likes this.
  7. ChhabiAcharya

    ChhabiAcharya Thread Starter

    Joined:
    Aug 4, 2017
    Messages:
    3
    Thanks for your responses and also for the idea about Sudoku. I haven't gone through its tutorials yet but now I'll try. Just one query, I don't want the variables to repeat in the same column but they can repeat in the same row...
     
  8. draceplace

    draceplace

    Joined:
    Jun 8, 2001
    Messages:
    2,583
    There were many Sudoku excel tutorials when 'Googled'. You may want to look a couple of them to see which one would better suit your project.
     
    ChhabiAcharya likes this.
  9. Sponsor

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 733,556 other people just like you!

Loading...
Tags:
Thread Status:
Not open for further replies.

Short URL to this thread: https://techguy.org/1194198

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice