SOLVED
Home

Replace cells where there is no formulas behind, with a cell where there is a formula behind

%3CLINGO-SUB%20id%3D%22lingo-sub-847628%22%20slang%3D%22en-US%22%3EReplace%20cells%20where%20there%20is%20no%20formulas%20behind%2C%20with%20a%20cell%20where%20there%20is%20a%20formula%20behind%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-847628%22%20slang%3D%22en-US%22%3E%3CP%3ESeveral%20cells%20where%20there%20is%20no%20formulas%20behind%20%26nbsp%3Bshould%20be%20replaced%20in%20one%20workflow%20with%20a%20cell%20where%20there%20is%20a%20formula%20behind%20with%20relative%20references.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHow%20can%20it%20be%20done%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBest%20Regards%3C%2FP%3E%3CP%3En-b_j%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-847628%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-848185%22%20slang%3D%22en-US%22%3ERe%3A%20Replace%20cells%20where%20there%20is%20no%20formulas%20behind%2C%20with%20a%20cell%20where%20there%20is%20a%20formula%20behind%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-848185%22%20slang%3D%22en-US%22%3EThese%20steps%3A%3CBR%20%2F%3E1.%20Select%20the%20area%20containing%20those%20cells%3CBR%20%2F%3E2.%20Press%20the%20F5%20function%20key%20(Goto)%3CBR%20%2F%3E3.%20Click%20Special%3CBR%20%2F%3E4.%20Choose%20Blanks%20and%20click%20OK%3CBR%20%2F%3E5.%20Start%20typing%20your%20formula%20as%20you%20usually%20would%3CBR%20%2F%3E6.%20Instead%20of%20pressing%20the%20Enter%20key%2C%20press%20control%20%2B%20Enter%20to%20insert%20this%20formula%20(using%20relative%20references!)%20into%20all%20selected%20cells.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-852444%22%20slang%3D%22en-US%22%3ERe%3A%20Replace%20cells%20where%20there%20is%20no%20formulas%20behind%2C%20with%20a%20cell%20where%20there%20is%20a%20formula%20behind%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-852444%22%20slang%3D%22en-US%22%3E%3CP%3EDear%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F22322%22%20target%3D%22_blank%22%3EJan%20Karel%20Pieterse%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank's%20for%20your%20answer%20%3A-).%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20forgot%20to%20describe%20that%20in%20the%20cells%20without%20formula%20behind%2C%20there%20is%20a%20time%20format%20with%20the%20time%2000%3A30%3A00.%20The%20cells%20do%20not%20necessarily%20stand%20side%20by%20side%2C%20but%20may%20have%20empty%20cells%20between%20them.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBest%20Regards%3C%2FP%3E%3CP%3En-b_j%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-853296%22%20slang%3D%22en-US%22%3ERe%3A%20Replace%20cells%20where%20there%20is%20no%20formulas%20behind%2C%20with%20a%20cell%20where%20there%20is%20a%20formula%20behind%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-853296%22%20slang%3D%22en-US%22%3EIn%20order%20to%20select%20those%20cells%20you%20could%20use%20find%2C%20if%20they%20all%20contain%20the%20same%20value%20you%20can%20click%20Find%20all.%20Then%20you%20can%20drag%20over%20the%20list%20of%20found%20items%2C%20close%20the%20dialog%20and%20enter%20the%20formula%20as%20I%20described%20already.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-857936%22%20slang%3D%22en-US%22%3ERe%3A%20Replace%20cells%20where%20there%20is%20no%20formulas%20behind%2C%20with%20a%20cell%20where%20there%20is%20a%20formula%20behind%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-857936%22%20slang%3D%22en-US%22%3E%3CP%3EDear%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F22322%22%20target%3D%22_blank%22%20rel%3D%22noopener%22%3E%26nbsp%3BJan%20Karel%20Pieterse%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYes%2C%20in%20the%20meantime%20before%20you%20answered%2C%20I%20found%20the%20solution%20myself.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBest%20Regards%3C%2FP%3E%3CP%3En-b_j%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
n-b_j
New Contributor

Several cells where there is no formulas behind  should be replaced in one workflow with a cell where there is a formula behind with relative references.

 

How can it be done?

 

 

Best Regards

n-b_j

4 Replies
These steps:
1. Select the area containing those cells
2. Press the F5 function key (Goto)
3. Click Special
4. Choose Blanks and click OK
5. Start typing your formula as you usually would
6. Instead of pressing the Enter key, press control + Enter to insert this formula (using relative references!) into all selected cells.
Solution

Dear Jan Karel Pieterse

 

 

Thank's for your answer :-).

 

I forgot to describe that in the cells without formula behind, there is a time format with the time 00:30:00. The cells do not necessarily stand side by side, but may have empty cells between them.

 

 

Best Regards

n-b_j

In order to select those cells you could use find, if they all contain the same value you can click Find all. Then you can drag over the list of found items, close the dialog and enter the formula as I described already.

Dear Jan Karel Pieterse

 

 

Yes, in the meantime before you answered, I found the solution myself.

 

 

Best Regards

n-b_j

Related Conversations
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
PacketMon Components are not loading in WAC 1909
HotCakeX in Windows Admin Center on
2 Replies