HOW DO U LOCK THE DATA | DeZyre

HOW DO U LOCK THE DATA

0

Divya Rani

AS IN , IN VLOOKUP... TO KEEP THE CELL CONSTANT HW TO WE LOCK IT

Absolute Reference

May 01 2014 04:45 PM

1 Answer(s)

0

Binny

When using VLookUp or any other formula, you need to make the cell constant (absolute reference) by pressing the F4 key. This will keep the value in that cell as constant.

May 04 2014 07:55 PM

Relevant Projects

Big Data Project Music Recommendation System Project using Python and R

Music Recommendation System Project using Python and R

Machine Learning Project - Work with KKBOX's Music Recommendation System dataset to build the best music recommendation engine.

Big Data Project Ecommerce product reviews - Pairwise ranking and sentiment analysis

Ecommerce product reviews - Pairwise ranking and sentiment analysis

This project analyzes a dataset containing ecommerce product reviews. The goal is to use machine learning models to perform sentiment analysis on product reviews and rank them based on relevance. Reviews play a key role in product recommendation systems.

Big Data Project Real-time Auto Tracking with Spark-Redis

Real-time Auto Tracking with Spark-Redis

Spark Project - Discuss real-time monitoring of taxis in a city. The real-time data streaming will be simulated using Flume. The ingestion will be done using Spark Streaming.

Big Data Project Hadoop Project for Beginners-SQL Analytics with Hive

Hadoop Project for Beginners-SQL Analytics with Hive

In this hadoop project, learn about the features in Hive that allow us to perform analytical queries over large datasets.

Big Data Project Forecast Inventory demand using historical sales data in R

Forecast Inventory demand using historical sales data in R

In this machine learning project, you will develop a machine learning model to accurately forecast inventory demand based on historical sales data.

Big Data Project Perform Time series modelling using Facebook Prophet

Perform Time series modelling using Facebook Prophet

In this project, we are going to talk about Time Series Forecasting to predict the electricity requirement for a particular house using Prophet.

Big Data Project Data Science Project-TalkingData AdTracking Fraud Detection

Data Science Project-TalkingData AdTracking Fraud Detection

Machine Learning Project in R-Detect fraudulent click traffic for mobile app ads using R data science programming language.

Big Data Project Human Activity Recognition Using Smartphones Data Set

Human Activity Recognition Using Smartphones Data Set

In this deep learning project, you will build a classification system where to precisely identify human fitness activities.

Big Data Project Tough engineering choices with large datasets in Hive Part - 1

Tough engineering choices with large datasets in Hive Part - 1

Explore hive usage efficiently in this hadoop hive project using various file formats such as JSON, CSV, ORC, AVRO and compare their relative performances

Big Data Project Analysing Big Data with Twitter Sentiments using Spark Streaming

Analysing Big Data with Twitter Sentiments using Spark Streaming

In this big data spark project, we will do Twitter sentiment analysis using spark streaming on the incoming streaming data.

Related Questions

for Vloop up function how to lock value in table_array parameter using keyboard shortcut?