This might work for a mom or pop operation and maybe even for a mom and pop operation

hi

There are 100 and more PDF files. Is there I want to edit the name only in 100 files so there is any software are any way please advise me

]]>There are 100 and more PDF files. Is there I want to edit the name only in 100 files so there is any software are any way please advise me

I started developing this in response to a question someone asked. It's a quick and dirty survey tool that could probably use some enhancement especially with trapping and gracefully exiting from errors. Anyway, it got me playing with forms which is something I don't get to do often.

The questions are set up on the Questions sheet. You can have as many questions as you wish. Each Question should have a unique number in column A. The text of the question is in column B. The possible answers, separated by commas are in column C and where to go next based on the selected answer is in column D. For example question 4 is "What is your favorite fruit?", the three possible answers are Apple, Orange and Peach. If you answer Apple, you go on to question 5, if you answer Orange, you go onto question 6 and if you answer Peach, you go on to question 10.

The results are recorded on the data sheet.

On file open and when exiting the survey, the Current Question is reset to 1.

The questions are set up on the Questions sheet. You can have as many questions as you wish. Each Question should have a unique number in column A. The text of the question is in column B. The possible answers, separated by commas are in column C and where to go next based on the selected answer is in column D. For example question 4 is "What is your favorite fruit?", the three possible answers are Apple, Orange and Peach. If you answer Apple, you go on to question 5, if you answer Orange, you go onto question 6 and if you answer Peach, you go on to question 10.

The results are recorded on the data sheet.

On file open and when exiting the survey, the Current Question is reset to 1.

Hi, My Son has some home work to work out the frequency of occurrence in some data and to work out the Mode. He is 9 years old and we are going to do this in his school note book. However I use spreadsheets at work and wanted to try and work this out using excel, more for my own interest than anything else but am struggling with getting the formulat correct. I have read the help file but it hasn't helped me. I have a medium knowledge of Excel better than basic but i am not an expert.

I have attached the spreadsheet i am using and would appreciate any help.

I have attached the spreadsheet i am using and would appreciate any help.

This has been rattling around in my head for a while. Some form of "generate all combinations/permutations of something" seems a common request/problem presented around here. Much of the time, the strategy recommended for generating these is some form of nested For..Next loops in VBA. Well, I decided to see if I could do it directly in the spreadsheet without VBA, (though I did use the basic idea of a For i=...Next i loop as my inspiration).

I chose the "all permuations of three numbers where the numbers can be 1 through 5" as my illustration. In VBA (and other programming languages), one might start with:

Of course, what the next statement does is look at the current value of ix. If ix is greater than or equal to 5, then it ends that loop. If not, it increments ix and goes back to the matching For statement.

In the first column, this is pretty easy. =IF(B5>=B$2,B$1,B5+1)

In subsequent columns, the test is more complex, but still relatively straightforward. =IF(AND(A5>=A$2,A6<>A5),IF(B5>=B$2,B$1,B5+1),B5)

Copy those formulas down as far as needed to get all permutations. Copy across to get more columns.

This example is only for numbers, but it can apply to other data types by simply storing the desired text or other values in an array, and accessing the elements using an INDEX() function. (I channeled my inner paleontologist for this one).

Of course, this is just a start for the kinds of problems that can be addressed. The strategy could be adapted to permutations without duplication or combinations where order does not matter. For now, this is a start to showing that this can be done without VBA.

I chose the "all permuations of three numbers where the numbers can be 1 through 5" as my illustration. In VBA (and other programming languages), one might start with:

Code:

`For i1=1 to 5`

For i2=1 to 5

For i3=1 to 5

'store i1, i2, i3 where you are storing your permutations

next i3

next i2

next i1

In the first column, this is pretty easy. =IF(B5>=B$2,B$1,B5+1)

In subsequent columns, the test is more complex, but still relatively straightforward. =IF(AND(A5>=A$2,A6<>A5),IF(B5>=B$2,B$1,B5+1),B5)

Copy those formulas down as far as needed to get all permutations. Copy across to get more columns.

This example is only for numbers, but it can apply to other data types by simply storing the desired text or other values in an array, and accessing the elements using an INDEX() function. (I channeled my inner paleontologist for this one).

Of course, this is just a start for the kinds of problems that can be addressed. The strategy could be adapted to permutations without duplication or combinations where order does not matter. For now, this is a start to showing that this can be done without VBA.