Attach a sample workbook. Make sure there is just enough data to make it clear what is needed. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are demonstrated, mock them up manually if needed. Remember to desensitize the data.
Click on GO ADVANCED and use the paperclip icon to open the upload window.
View Pic
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
Why Jan has 4 Weeks and Feb has 5 Weeks
and pls attach sample excel file
Samba
Say thanks to those who have helped you by clicking Add Reputation star.
See Attached. What I want is that if January will display only weeks 1 - 5 and if i choose from dropdown February It will be Weeks 1 - 5. in short, choosing from dropdown changes the Excel Cells
What is your expected Weeks for Feb 2015 and May 2015?
Originally Posted by :) Sixthsense :)
Weeks 1 - 4 for February and for May Weeks 1 - 5
Asking the same question asked by nflsales, what is the expected weeks for January 2015?
that was just an example you can refer as well to the calendar
We cannot offer something on assumption and we ask questions to understand to the logic to arrive the result.
So giving proper reply to our question will result as giving exact answer
Jan Weeks 1 - 5We cannot offer something on assumption and we ask questions to understand to the logic to arrive the result.
So giving proper reply to our question will result as giving exact answer
Feb Weeks 1 - 4
MArch Weeks 1 - 5
Arpril Weeks 1 - 5
May Weeks 1 - 5
June Weeks 1 - 5
July Weeks 1 - 5
August Weeks 1 - 5
SEpt Weeks 1 - 5
Oct Weeks 1 - 5
Nov Weeks 1 - 5
Dec Weeks 1 - 5
Try
F3=IF(B2="February","","Week 5")
In B3 Cell
=IF(COLUMNS($A:A)<=IF($B$2="February",4,5),"Week "&COLUMNS($A:A),"")
Drag it to right...
Oh Nearly Correct.In B3 Cell
=IF(COLUMNS($A:A)<=IF($B$2="February",4,5),"Week "&COLUMNS($A:A),"")
Drag it to right...
But I want Include at least 6 rows per column
Not sure what do you mean with that statement
Not sure what do you mean with that statement
Ex If I choose February It will display Weeks 1 - 4 inlcuding its Rows 1 - 6 per column
Are you talking about filling the formula down the rows? row 4 row5 row6 also?
Meaning if I put numbers(ex. 1) in B4 - B10, C4 - c10 until F4 - f10, so whatever data I have in January will not be seen in February
Why don't you use a pre made free template?
Check the attached file
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks