User Profile
gyankosh
Brass Contributor
Joined 6 years ago
User Widgets
Recent Discussions
Re: Excel Echos Data
You are typing 'echoes' but its converting to 42851. If this is the case, it seems like there is some problem in copying. 42851 seems to be a date format. Try changing the format to general or text. It'd be advisable if you could share the sheet.redheadfsa1.5KViews0likes6CommentsRe: Counting number of times the same entry has been entered in the previous 7 days.
If you just want to count , how many times the player fee has been added, a simple COUNTIF can be used. =countif(cell C3, "="PLAYER FEE") tHE OUTPUT WILL BE 1 OR 0. iT CAN BE COUNTED. IF YOU WANT CUMULATIVE SUM, MAKE ONE MORE COLUMN AND ADD THE UPPER CELL WITH THE CELL TO THE LEFT. I hope it helps. John74Racing1.9KViews0likes0Comments- 1.2KViews0likes0Comments
Re: Formula Help
WHAT I UNDERSTOOD You want to set a formula after which if you change text in a particular cell, it should reflect in a big range. for this just apply the formula suppose the text you want to be copied is at C3 then it should be =$c$3 in all the cells where you want to copy the text of c3. Now whatever you put in c3, it'll be copied to all the cells. it'll make the location absolute and you can copy it to as many cells as you want. you can refer here for more valuable information gyankosh.net/msexcel1.2KViews0likes3CommentsRe: Indirect Variable Addressing
Have a few doubts. The declared variable is an integer. If you want to send the final value to PB DONORS, why don't you declare it at module level or public i.e. project level variable. The output of first function is a string.What you want to do with that string. PB Donors is not going to take String as input as you have explicitly declared it. http://gyankosh.net/vba LaPaz5640819Views0likes1CommentRe: Need help. Pivot table average adding decimal places to whole number
Cheryle2175 No, you can achieve this. What I got from your problem. You are averaging the ratings, but its coming out to be in decimal. You want in a whole number. If 2.4 then 2 if 4.6 then 5. If its the case . Just follow this source:https://gyankosh.net/msexcel/how-to-use-pivot-tables-in-excel/#gsc.tab=0e When you go to the field settings, the picture shown above comes up. Just go to number format and choose one without the decimals. Your problem is solved. *If it was what I understood.8.5KViews0likes1CommentRe: Enter Number in cell and automaticaly tab to next cell
We need the event of key release for that. I have no idea if that is present in VBA or not. I think if its possible, it'll through VBA only. But the question is , how would VBA change the system settings that at each release of the key, the focus should move to next cell. Need some time to think about it. jacksiegel765KViews0likes0CommentsRe: function IF
Jeannedv Hi, if you have started learn if here, spend some time here https://gyankosh.net/msexcel/functions/logical/excel-function-if/ for your problem, I think nested if is good. If you had mentioned the cell, it'd have been better. =IF(M>80,"A",(IF(M>70,"B","FAIL"))) M is the cell address containing the marks1KViews0likes2Comments
Recent Blog Articles
No content to show