question

Instead of a number returned as expected the field has a '?'. Typical reasons why? Thanks in advance, Pikeboy

Context: I am trying to make a question bank to generate different assignment for each student so as to minimize copying... Task: I want to maintain a list of images in a sheet, let us call the sheet as LoI (for List of Images), and then I want randomly display a few of them on the Assignment...

Tl dr; I am trying to make a question bank where one of the question is match the following and I want to randomly select them to form an assignment. I am trying to make question bank in excel so that I can hand out a separate assignment sheet to each student. There are different types of...

Hello All I hope you can help on this please I have a drop down list in cell "P2" which allows me to select a value that then triggers a filter with the code shown below. Question 1 - How can I make this range Dynamic as the rows change daily. Question 2 - It is possible to put a value in...

I was just wondering if all questions get answered on this forum. I asked a question yesterday under the Excel questions, but it hasn't been answered but my other threads I asked same day were. Please don't take this the wrong way, I'm very grateful for everything you all have provided, all...

I have a set of data with different groups ("colors"). For each group (color), there are questions that apply to "categories" ("A", "B", "C", etc.). Each has a numerical score. I need to pick the highest scoring question for each category, for each group (color). Example: Group "Blue" has 2...

Hi! I've been searching but had no luck to find if there is any possible way to make a chart like this automatic in Excel, do you think it is possible? If yes... how so? Hope you can help, thanks in advance!

Sub Email() Application.Dialogs(xlDialogSendMail).Show End Sub so I have found the emal icon and put it on the ribbon.Even managed to record it in a macro. The Million dollar question can I get the TO option to fill from Cell A on SHEET1(which is email address)

Hi I have a table like the one below. I want to highlight empty cells to delete them etc. I went to GoTo Special, and clicked on Blank Cell but excel highlighted the cells inside the table and SOME outside the table too. Why excel highlighted the outside cells. To fix this issue, I had to...

Hi - I am a noob and this is my first post / question - hello to everyone I am merging two tables together with the first column of each table being matched. The problem I am having is that when they merge together I loose the order of the first table. How to I merge then together will...

I have a button that grabs data from several fields, formats them, puts that text string into a new field and copies it to the clipboard with the docmd ac.copy (not at that computer right now so the command may not be exactly right). My question is, rather than go through the step of pasting...

Hello all, First time Poster here, and novice in coding in general. My issue I am having is more a question of knowledge I feel. I am looking to scrap a java-script table on a secure site. So far I am able to log in but to get to the Data I want. There is a few buttons and links I must click...

Ok, im very new to Microsoft Access. My database knowledge comes from trail and error on SQL databases for Forums Like "PHP FUSION" I can pretty much do what ever i want using the sql command box. SO for my very first newbie question out of many to come im sure! Can you use sql santax in Access...

I have a table that has a range of cells in it <tbody> a b c d e f g h i j k l m n o p q r s t u v w x y 1 12 18 47 2 72 67 67 3 70 45 45 56 4 34 56 5 56 67 6 total...

Hi all I just want to copy a cell (A1) value down to A2. Only if B2 has a value. And so forth, copy A2 to A3 if B3 has a value. Thanks in advance, ColdGeorge

Good Afternoon, I've always had luck in this forum, hopefully my luck continues. I have column c filled with the results of a formula (date difference expressed in number of days). What would the formula be to change column C to: 1) If less than 14 days, display "0" 2) If greater than 14 days...

this may be more of a math question but in column A i have a rolling 12 month balance column B is a basis points assigned to a product Column C is the "new value" example below...my question is if a user only got the new value (column c) how could they back into column A (assuming they knew the...

Hi, I'm trying to calculate monthly returns from daily returns using geometric mean. I would like to be able to check the date array in column A of the attached document and locate the corresponding return array if the month and the year of the dates in question are equal to the month's returns...

Hi. On sheet2, I have a load of questions & answers from a survey. Row 90, Columns D and E contain Yes and No respectively as the answer options, with a tickbox in each cell, one of which is ticked for each question. On sheet1, I want to enter in cell b2 a formula which will return the result...

I have a excel question: Is there a way to count the number of times a number repeats in a string before another number replaces it. I am talking about consecutive repeats within a string such as below. What is the the longest run of 3 at any one time? 3 3 2 2 2 0 0 0 0 0 0 3 1 1 1...