excel

  1. M

    Beginner excel formula question

    Good day, I have an excel sheet with user data in it. It consumes quite a bit of time to manually count it, so I'm looking for a formula to do it quickly. Each data entry, lets say column A, has a user assigned to it, lets say column B. Pretty sure column A is not needed for this. I would like...
  3. G

    Ask me your Excel, Macro, VBA Questions

    I'm feeling generous. Lets see how many folks I can liberate from Spreadsheet hell....
    • gokool
    • Thread
    • excel excel problem excel scripting macro macros vba
    • Replies: 8
    • Forum: Software
  4. Johnatan56

    Excel Forumula

    Excel Formula Hi, stuck on an excel problem. I am trying to get all unique values from a column, and add its corresponding right value as a sum at the end. So say you had: A B 1 x 20 2 y 15 3 x 80 4 t 43 5 y 120 The result should be...
  5. I

    Office 2013 Home & Business - 16 retail license keys available - R300 each

    Office 2013 Home & Business retail license key (Word, Excel, PowerPoint, Outlook & OneNote). 16 x original retail license keys printed on a blue credit-card-sized card. Used previously, but not anymore. Can be legally activated on a different PC, as long as the license key is no longer used on...
    • InTheCube
    • Thread
    • buy cheap classified excel microsoft office office 2013 office 2016 one note outlook powerpoint purchase sale word
    • Replies: 4
    • Forum: Classifieds - For Sale
  6. S

    ODBC Drivers on Mac

    Hi I'm trying to find out how to setup a SQL Server driver, UserDSN, ODBC Data Source on a Macbook I have downloaded ODBC Manager.. but it wants drivers, Where do i find drivers, are they free or not? Is there another way to run a background sql query on an excel report? Any...
  7. Kevin Lancaster

    What it takes to be South Africa’s best Microsoft Excel user – here are the tasks

    What it takes to be South Africa’s best Microsoft Excel user – here are the tasks Here are the tasks the 10 South African Office Excel Championship semi-finalists are facing.
  8. T

    2nd Line Support Consultant

    The candidate will be required to fulfil and uphold the company values of personalised, high quality service by finding solutions to problems that users are experiencing. The candidate will become part of a young and dynamic team of technology enthusiasts. The candidate will be offered an...
    • Tech Recruiter
    • Thread
    • customer data desktop excel helpdesk install jobs line sandton sql support tech
    • Replies: 0
    • Forum: IT Jobs
  9. B

    Excel VBA to create a named range

    Excel 2016 macro workbook. I have a number of client lists based on the month they were activated. I need to create a named range for every month and want to minimise the number of time i spend to manually update the ranges. I created the following to create the named range: With...
  10. T

    Simple code creation

    Hi fellow people, I am struggling with a project I am assigned too. We have a simple site that needs a password to be logged into. I need to create passwords using numbers 100 to 2000 without repeating numbers. Each sequence must be unique and generate all sequences upfront so I can...
  11. J

    Best spreadsheet app for iPad?

    Hi there, I am looking for a better spreadsheet solution for iPad. I currently use Google sheets, Apple numbers, and Microsolf excel. I use all three because they each have their own limitations, and only the three together make up the full full set of features that I need. My most...
  12. L

    Excel Formula Win/Loss

    Hi, I need help with a formula that will deliver a win/loss % BUT I have 3 inputs: Win / Lost / Submitted (in adjudication so no feedback on status). Thanks
  13. S

    Tracking Electricity Usage

    Hi Guys Just thought I would share my excel sheet I use for tracking electricity usgae. https://mega.co.nz/#!PkNmzKiA!-zm2-dK6vm6h_jIw4K40Rp6FeBfVAyXkn9etJ6eruhI
  14. F

    Excel Macros Help

    I just started using Macros and need some help. Using Excel 2007 I managed to record a Macros and everything seems to be working except for the File Save as part.. I need to set it to use the orignal file name but the format set to csv instead of xls. I have several folders with excel sheets...
  15. M

    How to call values from another workbook

    Hi, I hope someone can assist me. I want to create a spreadsheet for food costing. I already have stock sheets with unit prices in excel spreadsheets. What I want it to create a sheet whereby I can select an ingredient (from a drop down list maybe), and enter a quantity in the given...
  16. carstensdj

    Free PDF --> Excel Converter?

    Hi There, So the company i work with is moving away from quoting through Excel, and we are going to be doing quotes through our Pastel Accounting Software. I have obtained all my suppliers pricelists, but some of them have only got PDF versions for me... So instead of typing out 1000's...
  17. R

    Calling fellow Excel power users

    I have a bit of a problem i can't get my head around. Yet its a very basic problem, i think :) I have tried google but i cannot think of the right question to ask! Anyway, If i do a concatenation between two cells and i arrive with a formula, when i paste that cell into another cell...
  18. I

    Need help with very Slow Excel Workbook

    Hi. A client of mine has been complaining about a particular Excel workbook (Excel file) that is running very slowly. Whenever they try to make changes to any of the cells, it takes about 10-20 seconds to make the change. Excel freezes up and becomes unresponsive during this time. I tested...
  19. A

    Any Excel Gurus out there?

    I need some help please. I am capturing marks and i have to retain the best 6 marks out of 8 tutorials. I'm using this formula> =(LARGE(D4:K4,1)+LARGE(D4:K4,2)+LARGE(D4:K4,3)+LARGE(D4:K4,4)+LARGE(D4:K4,5)+LARGE(D4:K4,6))/6 eg. 70 90 60 60 69 70 53 =69.83 The problem arises when a...
  20. S

    Excel -> mode()

    .
  21. S

    Excel date problem

    .
Back
Top
Sign up to the MyBroadband newsletter
X